PostgreSQL query failed: COPY state must be terminated first

Поиск
Список
Период
Сортировка
От Shane Wright
Тема PostgreSQL query failed: COPY state must be terminated first
Дата
Msg-id 200210171215.16081.me@shanewright.co.uk
обсуждение исходный текст
Ответы Re: PostgreSQL query failed: COPY state must be terminated first
Список 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 по дате отправления:

Предыдущее
От: "Robert John Shepherd"
Дата:
Сообщение: Re: pg_dump: query to get data of sequence "blahblahthis" returned name "blahblahthat"
Следующее
От: "Patrick Fiche"
Дата:
Сообщение: pg_attribute always grow...