Re: [SQL] Porting application with rules and triggers from PG 7.4.x

2006-04-27 Thread Andreas Haumer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! Sorry for the late response, but I'm quite busy and I wanted to test this before replying... Bruce Momjian schrieb: > Tom Lane wrote: >> Andreas Haumer <[EMAIL PROTECTED]> writes: >>> How can I get the functionality of an "deferred AFTER trigger"

Re: [SQL] Porting application with rules and triggers from PG 7.4.x

2006-04-21 Thread Bruce Momjian
Tom Lane wrote: > Andreas Haumer <[EMAIL PROTECTED]> 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. Do

Re: [SQL] Porting application with rules and triggers from PG 7.4.x to 8.1.3

2006-04-21 Thread Tom Lane
Andreas Haumer <[EMAIL PROTECTED]> 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

[SQL] Porting application with rules and triggers from PG 7.4.x to 8.1.3

2006-04-21 Thread Andreas Haumer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! I'm currently porting a rather complex application from PostgreSQL 7.4.x to 8.1.3 and I'm having problems with changed semantics of the trigger functionality. The problem is quite complex and I'm trying to describe the functionality involved as d