pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade from 7.3.4 to 7.4.6
3+ messages / 2 participants
[nested] [flat]
* Upgrade from 7.3.4 to 7.4.6
@ 2004-11-01 16:02 Cliff Reid <creid@proximitygroup.com>
0 siblings, 1 reply; 3+ messages in thread
From: Cliff Reid @ 2004-11-01 16:02 UTC (permalink / raw)
To: pgsql-admin
Hello
Can anyone point me to or near the reason why my pg_dumpall of my 7.3.4 DB
and subsequent 7.4.6 psql restoration of that dump show up as a failure when
I run my programs against it. I am using libpq as the DB interface.
Program results are successful on the 7.3.4 system but I get seg-faults when
attempting to run on 7.4.6.
Recap: (7.3.4) pg_dumpall mydb > mydb_dump; (7.4.6) psql -f mydb_dump; all
seem to go as expected until I run program procedures againt the 7.4.6 DB.
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.
I hope this is enough info for a reasonable response.
Thanks
Clifford Reid
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Upgrade from 7.3.4 to 7.4.6
@ 2004-11-01 17:20 Tom Lane <tgl@sss.pgh.pa.us>
parent: Cliff Reid <creid@proximitygroup.com>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2004-11-01 17:20 UTC (permalink / raw)
To: Cliff Reid <creid@proximitygroup.com>; +Cc: pgsql-admin
"Cliff Reid" <creid@proximitygroup.com> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* FW: Upgrade from 7.3.4 to 7.4.6
@ 2004-11-01 17:49 Cliff Reid <creid@proximitygroup.com>
0 siblings, 0 replies; 3+ messages in thread
From: Cliff Reid @ 2004-11-01 17:49 UTC (permalink / raw)
To: pgsql-admin
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" <creid@proximitygroup.com> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-11-01 17:49 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-01 16:02 Upgrade from 7.3.4 to 7.4.6 Cliff Reid <creid@proximitygroup.com>
2004-11-01 17:20 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-11-01 17:49 FW: Upgrade from 7.3.4 to 7.4.6 Cliff Reid <creid@proximitygroup.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox