<mdione.ext@xxxxxxxxxx> writes: > De : Tom Lane [mailto:tgl@xxxxxxxxxxxxx] >> You might try reindexing pg_trigger before doing anything more invasive, >> just in case the tuple is there but it's not being found because of a >> messed-up index. > Well, at some point we tried "REINDEX DATABASE pnssi_profiles_bench;" > and "REINDEX SYSTEM pnssi_profiles_bench;", would that be equivalent? Yeah, that would have covered it. > I'm pretty sure after what I have done some objects might still be > dangling in the db (even more, now that I remember, at some point we did > "delete from pg_trigger where tgname like '%01_110%';"; yes, I know, > it's a blunt approach). Is there any way to find those, if they exist? You could try the queries in the "oidjoins" regression test, which would verify all the implied foreign key relationships in the system catalogs. I don't think that covers pg_depend though; you'd need to gin up more complicated queries if you wanted to look for dangling pg_depend entries. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
