Re: Trigger before insert

From: "ON(dot)KG" <skyer(at)on(dot)kg>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger before insert
Date: 2004-11-25 15:02:40
Message-ID: 11127183609.20041125180240@on.kg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Witney 2004-11-25 15:07:02 Re: table name in pl/pgsql
Previous Message Richard Huxton 2004-11-25 13:45:20 Re: Benchmark-Comparison PostGreSQL vs. SQL Server

Browse pgsql-performance by date

  From Date Subject
Next Message Gary Doades 2004-11-25 20:35:25 Postgres backend using huge amounts of ram
Previous Message Richard Huxton 2004-11-25 12:54:46 Re: Trigger before insert