Query buffer problem.
Hi,
I insert 10,000 data into PostgreSQL database. I got the problem
while inserting:
query buffer max length of 20000 exceeded
query line ignored
.
query buffer max length of 20000 exceeded
query line ignored
');
PQsendQuery() -- query is too long. Maximum length is 8191
query buffer max length of 20000 exceeded
query line ignored
Segmentation fault (core dumped)
Would anyone know how to solve this problem, thanks in advance.
-Albert
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
Semicolon (;) at the end of each line should fix it.
-Dan
Show quoted text
Hi,
I insert 10,000 data into PostgreSQL database. I got the problem
while inserting:query buffer max length of 20000 exceeded
query line ignored
.
query buffer max length of 20000 exceeded
query line ignored');
PQsendQuery() -- query is too long. Maximum length is 8191
query buffer max length of 20000 exceeded
query line ignored
Segmentation fault (core dumped)Would anyone know how to solve this problem, thanks in advance.
-Albert
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
On Tue, 3 Aug 1999, Dan Wilson wrote:
Semicolon (;) at the end of each line should fix it.
ive seen the same thing happen with COPY dumps. seems like pg_dump doesnt
properly quote strings...
ill see if i can fix that up once i get some spare time, hopefully this
weekend.
Hi,
I insert 10,000 data into PostgreSQL database. I got the problem
while inserting:query buffer max length of 20000 exceeded
query line ignored
.
query buffer max length of 20000 exceeded
query line ignored');
PQsendQuery() -- query is too long. Maximum length is 8191
query buffer max length of 20000 exceeded
query line ignored
Segmentation fault (core dumped)Would anyone know how to solve this problem, thanks in advance.
-Albert
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
---
Howie <caffeine@toodarkpark.org> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
While you're at it, can you fix pg_dump to also dump the primary key
information to maintain that information.
Currently it dumps the Primary Keys as UNIQUE indices, which is OK, but if
you want to maintain that information across different dbms's you need the
primary key integrity.
-Dan
Show quoted text
On Tue, 3 Aug 1999, Dan Wilson wrote:
Semicolon (;) at the end of each line should fix it.
ive seen the same thing happen with COPY dumps. seems like pg_dump doesnt
properly quote strings...ill see if i can fix that up once i get some spare time, hopefully this
weekend.Hi,
I insert 10,000 data into PostgreSQL database. I got the problem
while inserting:query buffer max length of 20000 exceeded
query line ignored
.
query buffer max length of 20000 exceeded
query line ignored');
PQsendQuery() -- query is too long. Maximum length is 8191
query buffer max length of 20000 exceeded
query line ignored
Segmentation fault (core dumped)Would anyone know how to solve this problem, thanks in advance.
-Albert
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com---
Howie <caffeine@toodarkpark.org> URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."
