Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group