On Mon, Mar 29, 1999 at 06:25:13AM +0000, Constantin Teodorescu wrote:
> junho91@kmail.com wrote:
> >
> > Hello...
> > I am using postgresSQL....
> > I am facing a difficult problem..
> >
> > it was occured error below
> > ==========================
> > Warning: PostgresSQL query failed: PQexec() -- query is too long.
> > Maximum length is 8191 in /home/httpd/html/lline/add.php3 on line 151
> > ==========================
> As I know, it's not possible to write a query bigger than 8191 bytes.
> But in real world, that's supposed to happen extremely rare.
It would depend upon your database. I'm handling a bug database
with some rather large text fields. If someone pastes 8k of text into
one of them, the INSERT statement will fail for that reason.
I would like to know if there is a simple solution to this as well,
or if it will be addressed in the future. I do have other options, but
they entail shuffling a lot of legacy data around.
