pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adam Haberlach <haberlaa@ricochet.net>
To: PostgreSQL Interfaces <pgsql-interfaces@postgresql.org>
Subject: Re: [INTERFACES] Re: I am facing a difficult problem..
Date: Sun, 28 Mar 1999 22:39:11 -0800
Message-ID: <19990328223910.A4338@ricochet.net> (raw)
In-Reply-To: <36FF1CC9.3DE5BE66@flex.ro>
References: <199903290210.LAA00030@kmail.com>
	<36FF1CC9.3DE5BE66@flex.ro>

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.



view thread (5+ messages)  latest in thread

Message-ID: <19990328223910.A4338@ricochet.net>
Permalink:  ../19990328223910.A4338@ricochet.net/
Also on:    postgresql.org/message-id/19990328223910.A4338@ricochet.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: haberlaa@ricochet.net
  Subject: Re: [INTERFACES] Re: I am facing a difficult problem..
  In-Reply-To: <19990328223910.A4338@ricochet.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox