PostgreSQL query failed: COPY state must be terminated first - Mailing list pgsql-general

From Shane Wright
Subject PostgreSQL query failed: COPY state must be terminated first
Date
Msg-id 200210171215.16081.me@shanewright.co.uk
Whole thread Raw
Responses Re: PostgreSQL query failed: COPY state must be terminated first
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

I have a (PHP) script that pulls a whole bunch of data from the database, does
a bit to it and spits it out, but with a large set of data, I'm getting some
really weird things happen!

After doing a chunk of it (same place every time), it dies with this error:

PostgreSQL query failed: COPY state must be terminated first

And I get a whole bunch of random gubbins outputted too...



oDøÀ
server sent data ("D" message) without prior row description ("T" message)

server sent data ("D" message) without prior row description ("T" message)

server sent data ("D" message) without prior row description ("T" message)

server sent data ("D" message) without prior row description ("T" message)

server sent data ("D" message) without prior row description ("T" message)

server sent data ("D" message) without prior row description ("T" message)

unexpected character Y following empty query response ("I" message)

server sent data ("D" message) without prior row description ("T" message)

oDùÀ
oDùÀ
server sent data ("D" message) without prior row description ("T" message)

server sent data ("D" message) without prior row description ("T" message)

server sent data ("D" message) without prior row description ("T" message)

oDùÀ
server sent binary data ("B" message) without prior row description ("T"
message)

server sent binary data ("B" message) without prior row description ("T"
message)

server sent data ("D" message) without prior row description ("T" message)

server sent data ("D" message) without prior row description ("T" message)

server sent data ("D" message) without prior row description ("T" message)



or this:

oDùÀ
oDùÀ
CE
unexpected character C following empty query response ("I" message)



...which all seems very strange - I'm not using a COPY (only SELECTs), and
I've no idea what the rest means.

Anyone seen this before?  Any idea what or why or how to fix it?  I'm using
PostgreSQL 7.1.3 and PHP 4.1.1  (I know, I know, upgrade..  but I can't as
its on my ISPs server..)

Any help or any ideas appreciated...

Cheers

- --
Shane
http://www.shanewright.co.uk/
Public key: http://www.shanewright.co.uk/files/public_key.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE9rpvE5DXg6dCMBrQRAtstAKCtxynOlPuOqKGV1csinhD+93cQDQCghwUN
WjftHUqLKjo4jEy4HAXGmtw=
=Il/B
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: "Robert John Shepherd"
Date:
Subject: Re: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat"
Next
From: "Patrick Fiche"
Date:
Subject: pg_attribute always grow...