From: | "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Listing Triggers corresponding to foreign keys |
Date: | 2000-10-10 14:03:23 |
Message-ID: | 996802F75C3CD411B424001083FA445B0594D8@CET_PONXX_FP001 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
Am I right in saying that when you add a constraint to a table it just
produces three triggers? If so which triggers?
There seems to be no easy way of listing triggers (or rules). I assumed
there was something like \d? which would do the job but could find nothing
in the docs. I can find a list in pg_trigger but am not sure of the
details.
BTW are there any docs for each of the system tables as there seems to be no
other way to certain things than dive into these and work what each does!!
It says in the docs to drop constraints on a table you drop the table and
remake it, but I only want to drop one of the constraints, do I just have to
drop the triggers (When I have found out which ones) or drop and remake the
table and then remake the other constraints.
Any help would be appreciated.
Ben
From | Date | Subject | |
---|---|---|---|
Next Message | andrew | 2000-10-10 14:18:46 | Re: Making changes visible to other connections |
Previous Message | Oleg Bartunov | 2000-10-10 13:52:07 | Re: PostgreSQL encoding question |