pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Upgrade 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