Horton

Re: BUG #2379: Duplicate pkeys in table

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Philip Warner <pjw@rhyme.com.au>
Cc: pgsql-bugs@postgresql.org
Date: 2006-04-06T16:07:08Z
Lists: 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