"Ansley, Michael" wrote:
>Hi, all
>
>I dumped a table using pg_dump, and then tried to import it into a new
>database. Of the ~210,000 records in the original table, only about 193,000
>were loaded, and the remainder caused an error: something about the query
>buffer being too small. Now, I know that queries are limited in size, due
>to the size of the query buffer, but none of these insert queries are longer
>than about 600 characters. Is it possible that the stream from the dump
>file is causing the buffer to overflow by simply overloading it with
>incoming queries, and if so, how do I prevent this? If not, then does
>anybody have any idea what the problem is.
The problem is some kind of syntax error in the dump output that makes
the parser think a query is not finished, so it runs together many
queries until it runs out of space. You need to find where the error is
occurring and correct the dump script.
--
Vote against SPAM: http://www.politik-digital.de/spam/
========================================
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Jesus said unto her, I am the resurrection, and the
life; he that believeth in me, though he were dead,
yet shall he live." John 11:25
