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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org