Received: from rgate4.ricochet.net (rgate4.ricochet.net [204.179.143.4]) by hub.org (8.9.2/8.9.1) with ESMTP id BAA37087 for ; Mon, 29 Mar 1999 01:39:20 -0500 (EST) (envelope-from adam@bamf.frotz.net) Received: from socket.house (mg-20425426-222.ricochet.net [204.254.26.222]) by rgate4.ricochet.net (8.8.8/8.8.8) with ESMTP id AAA27558 for ; Mon, 29 Mar 1999 00:39:14 -0600 (CST) Received: from adam by socket.house with local (Exim 2.05 #1 (Debian)) id 10RVhX-00018J-00; Sun, 28 Mar 1999 22:39:11 -0800 Date: Sun, 28 Mar 1999 22:39:11 -0800 From: Adam Haberlach To: PostgreSQL Interfaces Subject: Re: [INTERFACES] Re: I am facing a difficult problem.. Message-ID: <19990328223910.A4338@ricochet.net> References: <199903290210.LAA00030@kmail.com> <36FF1CC9.3DE5BE66@flex.ro> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.3i In-Reply-To: <36FF1CC9.3DE5BE66@flex.ro>; from Constantin Teodorescu on Mon, Mar 29, 1999 at 06:25:13AM +0000 Sender: Adam Haberlach 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.