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-----
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" |