Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger before insert - Mailing list pgsql-general

From ON.KG
Subject Re: Trigger before insert
Date
Msg-id 11127183609.20041125180240@on.kg
Whole thread Raw
In response to Re: Trigger before insert  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
Hi!

>> How could i stop Inserting record into table by some condition?

RH> RETURN null when using a before trigger. Or raise an exception to abort
RH> the whole transaction.

Thanx ;)
RETURN NULL works so as i need

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Trigger before insert
Next
From: Shridhar Daithankar
Date:
Subject: Re: Benchmark-Comparison PostGreSQL vs. SQL Server