Thread: Triggers

On Fri, 22 Sep 2000, Enrico Comini wrote:

> Question
> If have a table with a primary key and another table with outer key
> referenced on the primary of the first table.
> If I want list the active triggers how i have to do ?

select * from pg_trigger;

> If I delete de first table I have the message (drop table implicity drop
> reference .......), Then I re-create the first table, my question is how to
> re-create the trigger without drop and re-create the second table.

Probably your best bet is to:
ALTER TABLE <second table> ADD CONSTRAINT <constraintname>
 FOREIGN KEY (<cols>) REFERENCES ...