Re: BUG #2379: Duplicate pkeys in table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2379: Duplicate pkeys in table
Date
Msg-id 25078.1144339628@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #2379: Duplicate pkeys in table  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: BUG #2379: Duplicate pkeys in table  (Philip Warner <pjw@rhyme.com.au>)
Re: BUG #2379: Duplicate pkeys in table  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-bugs
Philip Warner <pjw@rhyme.com.au> writes:
>  aView_update_r1 AS
>     ON UPDATE TO aView DO INSTEAD  UPDATE brokenTable SET f1 = new.f1
>   WHERE brokenTable.id = new.id
>  aView_update_r2 AS
>     ON UPDATE TO aView DO INSTEAD  UPDATE brokenTable SET f2 = new.f2
>   WHERE brokenTable.id = new.id

OK, that's a bit clearer.  It'd help to see the view definition too.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Philip Warner
Date:
Subject: Re: BUG #2379: Duplicate pkeys in table
Next
From: Philip Warner
Date:
Subject: Re: BUG #2379: Duplicate pkeys in table