pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCHECKS vs. BEFORE INSERT OR UPDATE TRIGGER
2+ messages / 2 participants
[nested] [flat]
* CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER
@ 2002-12-16 16:41 Ludwig Lim <lud_nowhere_man@yahoo.com>
2002-12-16 16:56 ` Re: CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER Michael Paesold <mpaesold@gmx.at>
0 siblings, 1 reply; 2+ messages in thread
From: Ludwig Lim @ 2002-12-16 16:41 UTC (permalink / raw)
To: pgsql-sql
Hi:
I am just wondering. Which one is executed first:
CHECK Constraints or BEFORE INSERT OR UPDATE TRIGGER?
Thank you very much,
ludwig.
__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER
2002-12-16 16:41 CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER Ludwig Lim <lud_nowhere_man@yahoo.com>
@ 2002-12-16 16:56 ` Michael Paesold <mpaesold@gmx.at>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Paesold @ 2002-12-16 16:56 UTC (permalink / raw)
To: Ludwig Lim <lud_nowhere_man@yahoo.com>; pgsql-sql
Ludwig Lim <lud_nowhere_man@yahoo.com> wrote:
> I am just wondering. Which one is executed first:
> CHECK Constraints or BEFORE INSERT OR UPDATE TRIGGER?
First the BEFORE... TRIGGERs, then the CHECK contraints,
so you definetly can change a row in a trigger to match
the contraints...
Regards,
Michael Paesold
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-12-16 16:56 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-12-16 16:41 CHECKS vs. BEFORE INSERT OR UPDATE TRIGGER Ludwig Lim <lud_nowhere_man@yahoo.com>
2002-12-16 16:56 ` Michael Paesold <mpaesold@gmx.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox