Skip site navigation (1) Skip section navigation (2)

Re: Only first statement of two in update-rule is executing?

From: David Owen <dsowen(at)fugue88(dot)ws>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Only first statement of two in update-rule is executing?
Date: 2008-01-30 05:47:14
Message-ID: Pine.LNX.4.64.0801292245370.11333@tux.l.fugue88.ws (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-general by date

Next:From: Sim ZacksDate: 2008-01-30 06:18:06
Subject: Re: PGCon vs Postgresql Conference
Previous:From: David OwenDate: 2008-01-30 05:18:16
Subject: Re: Only first statement of two in update-rule is executing?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group