Re: Trigger before insert

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2004-11-25 13:06:06 Re: Benchmark-Comparison PostGreSQL vs. SQL Server
Previous Message Richard Huxton 2004-11-25 12:52:49 Re: Benchmark-Comparison PostGreSQL vs. SQL Server

Browse pgsql-performance by date

  From Date Subject
Next Message ON.KG 2004-11-25 15:02:40 Re: Trigger before insert
Previous Message Dave Cramer 2004-11-25 12:38:23 Re: Postgres vs. MySQL