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
