On Sun, Feb 16, 2025 at 5:58 PM Marcelo Fernandes <marcefe...@gmail.com> wrote:
> - The foreign keys are not being updated to point to the new table. > You started out okay with your test script, but the pg_depend bit needs work. I would recommend examining that table closely until you have a really good understanding of how it works - both on the objid and refobjid side. Create and modify tables and see how the pg_depend entries change. Hint: Try it with and without foreign keys. https://www.postgresql.org/docs/current/catalog-pg-depend.html > - pg_repack seems to update relcache entries. I am not sure how to do that > with SQL. Yes, as I mentioned upthread, the safest thing will probably be a restart. Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support
