Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger before insert - Mailing list pgsql-general

From Richard Huxton
Subject Re: Trigger before insert
Date
Msg-id 41A5D616.4090308@archonet.com
Whole thread Raw
In response to Trigger before insert  ("ON.KG" <skyer@on.kg>)
Responses Re: Trigger before insert
List pgsql-general
Tree view 
ON.KG wrote:
>
> How could i stop Inserting record into table by some condition?

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

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

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