Re: [INTERFACES] Re: I am facing a difficult problem..

From: Adam Haberlach <haberlaa(at)ricochet(dot)net>
To: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [INTERFACES] Re: I am facing a difficult problem..
Date: 1999-03-29 06:39:11
Message-ID: 19990328223910.A4338@ricochet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Mon, Mar 29, 1999 at 06:25:13AM +0000, Constantin Teodorescu wrote:
> junho91(at)kmail(dot)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.

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ari Halberstadt 1999-03-29 11:09:20 Re: [INTERFACES] Re: I am facing a difficult problem..
Previous Message Constantin Teodorescu 1999-03-29 06:25:13 Re: I am facing a difficult problem..