Re: bug in 1.6 rc1 - Mailing list pgadmin-support

From Dave Page
Subject Re: bug in 1.6 rc1
Date
Msg-id 454FAC5F.4090509@postgresql.org
Whole thread Raw
In response to Re: bug in 1.6 rc1  ("Belbin, Peter" <PBelbin@McLeodUSA.com>)
List pgadmin-support
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.


pgadmin-support by date:

Previous
From: "Keith C. Perry"
Date:
Subject: Re: pgadmin3 1.6 handling of tables with bytea's
Next
From: "Belbin, Peter"
Date:
Subject: Re: bug in 1.6 rc1