On 11 November 2011 12:25, Gregg Jaskiewicz <gryzman@xxxxxxxxx> wrote: > So I have a strange issue on one of our live systems. > > > \d+ table shows me the FKs with cascaded deletes, but querying > pg_trigger doesn't show me any specific triggers for the FK. > Is that possible ? Or am I missing something here? > > The psql version is 8.3.7 . What happened it seems was that the box run out of disk space (it's a test box), and postgresql (obviously) kicked the bucket. Was restarted, and worked fine until I've noticed the FK problem. I was trying to get a backup just now, and got this: pg_dump: failed sanity check, parent table OID 1026802 of pg_rewrite entry OID 1026968 not found Questions: - how to fix it - is it something that's been fixed in 8.3.x, where x > 7 ? -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
