| 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: | Whole Thread | Raw Message | 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.
| 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 |