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

From Belbin, Peter
Subject Re: bug in 1.6 rc1
Date
Msg-id DAC7935736BD9F4AAC601EE021D1B2340613370C@txhouexch01.mcld.net
Whole thread Raw
In response to bug in 1.6 rc1  ("Belbin, Peter" <PBelbin@McLeodUSA.com>)
Responses Re: bug in 1.6 rc1  (Dave Page <dpage@postgresql.org>)
List pgadmin-support
<p><font size="2">Cool.  Thank you for fixing it.</font><p><font size="2">Will the next packaged release candidate be
anytime soon?</font><br /><p><font size="2">-----Original Message-----</font><br /><font size="2">From: Dave Page [<a
href="mailto:dpage@postgresql.org">mailto:dpage@postgresql.org</a>]</font><br /><font size="2">Sent: Monday, November
06,2006 3:43 PM</font><br /><font size="2">To: Belbin, Peter</font><br /><font size="2">Cc:
'pgadmin-support@postgresql.org'</font><br/><font size="2">Subject: Re: [pgadmin-support] bug in 1.6 rc1</font><p><font
size="2">Belbin,Peter wrote:</font><br /><font size="2">> Here is a table def:</font><br /><font size="2">>
</font><br/><font size="2">> CREATE TABLE st_txn</font><br /><font size="2">> (</font><br /><font size="2">>  
txnidvarchar(40),</font><br /><font size="2">>   txnorder varchar(10) NOT NULL,</font><br /><font size="2">>  
txnstagevarchar(10) NOT NULL,</font><br /><font size="2">>   txnseq varchar(10),</font><br /><font size="2">>  
verbvarchar(40),</font><br /><font size="2">>   payload varchar(65000),</font><br /><font size="2">>   status
varchar(10),</font><br/><font size="2">>   agent varchar(60),</font><br /><font size="2">>   id serial NOT
NULL,</font><br/><font size="2">>   CONSTRAINT st_txn_pk PRIMARY KEY (id)</font><br /><font size="2">>
)</font><br/><font size="2">> WITH OIDS;</font><p><font size="2">Thanks. It appears that the error is actually that
MakeKey()is failing </font><br /><font size="2">to create a proper WHERE clause for the update query in cases where a
</font><br/><font size="2">table has both OIDs and a primary key. I've fixed that bug in SVN and </font><br /><font
size="2">yourexample now works fine.</font><p><font size="2">Thanks for the report.</font><p><font size="2">Regards,
Dave.</font><br/><br /><p><b><font size="2">NOTICE: This electronic mail transmission may contain confidential
informationand is intended only for the person(s) named.  Any use, copying or disclosure by any other person is
strictlyprohibited. If you have received this transmission in error, please notify the sender via e-mail.</font></b><br
/><br/> 

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: bug in 1.6 rc1
Next
From: Igor Kozlov
Date:
Subject: A request about pgAdmin