RE: [GENERAL] trigger problem?

From: "Oren Teich" <teich(at)cobaltnet(dot)com>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: RE: [GENERAL] trigger problem?
Date: 2000-01-07 20:29:57
Message-ID: LDEIJMIHBGLDIEOIGPEHMEKHCBAA.teich@cobaltnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

As a follow up to my last post,
after some more testing, it appears that triggers for delete or insert work
as expected, i.e. if multiple triggers on the same table are defined they
each get called on a insert or delete. For updates however, only the first
trigger defined on a relation seems to get called.

I defined 6 triggers - 3 "AFTER INSERT OR DELETE" and 3 "AFTER UPDATE". All
3 triggers on the insert and delete are getting called - the data apperars
and disappears as expected in the tables. On an update, however, all the
data is gone except for data populated by the first trigger defined.

Short of rewriting my SQL to delete/insert instead of update, is there
anything I can do?

thanks,
Oren Teich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Chmara 2000-01-08 03:17:30 Re: [GENERAL] Re: MySQL / PostgreSQL (was: Postgres object orientation)
Previous Message ^chewie 2000-01-07 19:26:45 Re: [GENERAL] Re: MySQL / PostgreSQL (was: Postgres object orientation)