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."
>