| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brian McCane <bmccane(at)mccons(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Listing Triggers |
| Date: | 2002-01-30 18:26:44 |
| Message-ID: | 24961.1012415204@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
Brian McCane <bmccane(at)mccons(dot)net> writes:
> Thanks Tom and Arguile that definitely helps. Now for my more
> pressing, but forgotten question. Shouldn't PostgreSQL have automatically
> dropped that trigger when I dropped the table?
It should, and it does.
IIRC, there's a bug in some versions of pg_dump that loses the
connection between a foreign-key trigger and the referenced table
(ie, the tgconstrrelid link) when you dump and reload. If you can
exhibit an instance of misbehavior otherwise, I'd like to see it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-01-30 18:31:43 | Re: Listing Triggers |
| Previous Message | Brian McCane | 2002-01-30 18:00:13 | Re: Listing Triggers |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2002-01-30 18:31:43 | Re: Listing Triggers |
| Previous Message | Brian McCane | 2002-01-30 18:00:13 | Re: Listing Triggers |