Re: bug in 1.6 rc1

[Dave Page <dpage(at)postgresql(dot)org>]

Belbin, Peter wrote:
> Here is a table def:
>
> CREATE TABLE st_txn
> (
>   txnid varchar(40),
>   txnorder varchar(10) NOT NULL,
>   txnstage varchar(10) NOT NULL,
>   txnseq varchar(10),
>   verb varchar(40),
>   payload varchar(65000),
>   status varchar(10),
>   agent varchar(60),
>   id serial NOT NULL,
>   CONSTRAINT st_txn_pk PRIMARY KEY (id)
> )
> WITH OIDS;

Thanks. It appears that the error is actually that MakeKey() is failing 
to create a proper WHERE clause for the update query in cases where a 
table has both OIDs and a primary key. I've fixed that bug in SVN and 
your example now works fine.

Thanks for the report.

Regards, Dave.