Greetings,
I am sure I have seen this, but I have searched the docs, and
tried to search the archives, which was a definite exercise in futility.
How can I list the triggers on a specific table? I tried the following:
= select * from pg_trigger where tgargs like '%foo%' ;
ERROR:
Brian McCane [EMAIL PROTECTED] writes:
How can I list the triggers on a specific table?
select * from pg_trigger where tgrelid =
(select oid from pg_class where relname = 'foo');
This table is documented now in the 7.2 documentation; see
Brian McCane wrote:
How can I list the triggers on a specific table?
Just as I was typing this I noticed Tom already replied. Just incase you
want to know all triggers referencing the table in addition to those on it
(eg. foreign key constraints).
SELECT t.oid, t.*
FROM pg_trigger t,
On Wed, 30 Jan 2002, Arguile wrote:
Brian McCane wrote:
How can I list the triggers on a specific table?
Just as I was typing this I noticed Tom already replied. Just incase you
want to know all triggers referencing the table in addition to those on it
(eg. foreign key constraints).
On Wed, 30 Jan 2002, Brian McCane wrote:
On Wed, 30 Jan 2002, Arguile wrote:
Brian McCane wrote:
How can I list the triggers on a specific table?
Just as I was typing this I noticed Tom already replied. Just incase you
want to know all triggers referencing the table in addition to
Brian McCane [EMAIL PROTECTED] 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