| From: | Somazx Interesting <somazx(at)home(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | orphaned RI constraints |
| Date: | 2001-07-06 19:18:10 |
| Message-ID: | 5.1.0.14.2.20010706120306.03ccb848@mail.rct1.bc.wave.home.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm working with two different postgres installations - they're both
v7.1.2. On one I can drop a table and the related constraint info seems to
go away with the table, on the other the restraint trigger seems to remain
in the system tables and then when I try to delete rows from tables once
related to the dropped table I get errors saying the dropped tabled doesn't
exist - which I'm interpreting as the RI trigger trying to do its thing and
failing.
Questions:
1) Is this possible, or should I look for another explanation.
2) Can I fix things by dropping the constraint info from the system tables,
if so how? Is there a function which cleans the system tables checking for
problems like orphaned triggers, functions and sequences?
Thanks,
Andy.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-07-06 19:47:42 | Re: Number of days |
| Previous Message | omid omoomi | 2001-07-06 19:07:50 | Re: Number of days |