Re: Only first statement of two in update-rule is executing? - Mailing list pgsql-general

From David Owen
Subject Re: Only first statement of two in update-rule is executing?
Date
Msg-id Pine.LNX.4.64.0801292245370.11333@tux.l.fugue88.ws
Whole thread Raw
In response to Re: Only first statement of two in update-rule is executing?  (David Owen <dsowen@fugue88.ws>)
List pgsql-general
On Tue, 29 Jan 2008, David Owen wrote:

> On Tue, 29 Jan 2008, David Owen wrote:
>
> I discovered that if I change the rule to only do the insert, I still have
> troubles.  The first update to simple2 will insert an row, but a second
> update will give a duplicate primary key error.

Sorry, that's a bad path (it's late).  After the first update, there are
now two rows in simple1.  The second update applys to both, so attempts to
create two new rows having the same timestamp.  Ah well.

-David

pgsql-general by date:

Previous
From: David Owen
Date:
Subject: Re: Only first statement of two in update-rule is executing?
Next
From: Sim Zacks
Date:
Subject: Re: PGCon vs Postgresql Conference