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 versio
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 a
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).
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, pg_clas
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
http://developer.postgresql.org/docs/postgres/catalog-
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: Unabl
