Thread: 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 > 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 > 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." >
Hi, Can some one guide me how can I unsubscribe from this list . ralli@poboxes.com