X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 37A1E3A45F9 for ; Mon, 1 Nov 2004 17:49:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 06121-07 for ; Mon, 1 Nov 2004 17:49:46 +0000 (GMT) Received: from hades.ny.proximity.com.au (yankee.proximitygroup.com [64.59.57.10]) by svr1.postgresql.org (Postfix) with ESMTP id 4EBF23A45E9 for ; Mon, 1 Nov 2004 17:49:45 +0000 (GMT) Received: from orion (orion.ny.proximity.com.au [192.168.0.30]) by hades.ny.proximity.com.au (Postfix) with ESMTP id F3DB228C098 for ; Mon, 1 Nov 2004 12:49:43 -0500 (EST) From: "Cliff Reid" To: Subject: FW: Upgrade from 7.3.4 to 7.4.6 Date: Mon, 1 Nov 2004 12:49:43 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AcTANwkAA1bj88QsTS6MOZxVSsZzcAAAEL5wAAD2QpA= X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Message-Id: <20041101174944.F3DB228C098@hades.ny.proximity.com.au> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/16 X-Sequence-Number: 15401 Clifford Reid Proximity Corporation Vice President, Global Product Support 1065 Avenue of the Americas, 26th Floor New York, New York 10018 Tel: 646-452-5820 Fax: 646-452-5821 Cell: 212-300-5639 creid@proximitygroup.com -----Original Message----- From: Cliff Reid [mailto:creid@proximitygroup.com] Sent: Monday, November 01, 2004 12:27 PM To: 'Tom Lane' Subject: RE: [ADMIN] Upgrade from 7.3.4 to 7.4.6 Tom Thanks for the reply, much appreciated. On-the-wire is a step in the right direction. To get a bit more out of you regarding this issue, what exactly is the correct method for receiving proper data representation? Is there a play that I can use with the existing PG utilities and/or SQL statements? Best regards, Clifford Reid Proximity Corporation Vice President, Global Product Support 1065 Avenue of the Americas, 26th Floor New York, New York 10018 Tel: 646-452-5820 Fax: 646-452-5821 Cell: 212-300-5639 creid@proximitygroup.com > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Monday, November 01, 2004 12:20 PM > To: Cliff Reid > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Upgrade from 7.3.4 to 7.4.6 > > "Cliff Reid" writes: > > My instant analysis: It seems to not like BINARY CURSOR. When I remove > > BINARY from the SQL DECLARE string, I no longer receive the seg-fault > but > > the data results (presentation) are not as expected. > > 7.4 changed the external representation in which BINARY CURSOR results > are delivered. Before 7.4 you got the (very machine- and even version- > dependent) server internal representation; now you get an on-the-wire > representation that we hope to keep stable. > > regards, tom lane