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 по дате отправления: