Re: insert rule instead oddity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Sim Zacks <sim(at)compulab(dot)co(dot)il>, pgsql-general(at)postgresql(dot)org
Subject: Re: insert rule instead oddity
Date: 2007-03-13 15:19:36
Message-ID: 2498.1173799176@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> I don't think rules can do what you want.

A trigger might work, ignoring the problem of race conditions between
two inserts happening concurrently (which a rule can't handle either).

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-03-13 15:27:58 Re: Multi DB performance test
Previous Message Olivier Ceulemans 2007-03-13 15:00:38 More information on how to understand table pg_locks.