Postgres Pro
Downloads
Home   >   mailing lists

Re: Porting application with rules and triggers from PG 7.4.x to 8.1.3 - Mailing list pgsql-sql

From Tom Lane
Subject Re: Porting application with rules and triggers from PG 7.4.x to 8.1.3
Date
Msg-id 9596.1145630282@sss.pgh.pa.us
Whole thread Raw
In response to Porting application with rules and triggers from PG 7.4.x to 8.1.3  (Andreas Haumer <andreas@xss.co.at>)
Responses Re: Porting application with rules and triggers from PG 7.4.x  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
Andreas Haumer <andreas@xss.co.at> writes:
> How can I get the functionality of an "deferred AFTER trigger"
> again with PostgreSQL 8?

Use CREATE CONSTRAINT TRIGGER.  The manual is fairly negative about this
but I don't actually foresee it going away any time soon.
        regards, tom lane

pgsql-sql by date:

Previous
From: Andreas Haumer
Date:
Subject: Porting application with rules and triggers from PG 7.4.x to 8.1.3
Next
From: Jeff Frost
Date:
Subject: find all tables with a specific column name?