Re: bug in 1.6 rc1

From: Dave Page <dpage(at)postgresql(dot)org>
To: "Belbin, Peter" <PBelbin(at)mcleodusa(dot)com>
Cc: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: bug in 1.6 rc1
Date: 2006-11-06 21:42:55
Message-ID: 454FAC5F.4090509@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Belbin, Peter 2006-11-06 22:28:50 Re: bug in 1.6 rc1
Previous Message Keith C. Perry 2006-11-06 21:40:11 Re: pgadmin3 1.6 handling of tables with bytea's