PostgreSQL query failed: COPY state must be terminated first

From: Shane Wright <me(at)shanewright(dot)co(dot)uk>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL query failed: COPY state must be terminated first
Date: 2002-10-17 11:15:16
Message-ID: 200210171215.16081.me@shanewright.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Fiche 2002-10-17 12:37:57 pg_attribute always grow...
Previous Message Robert John Shepherd 2002-10-17 10:30:35 Re: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat"