Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id UAA24963 for ; Wed, 14 Jul 1999 20:28:34 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id UAA28613; Wed, 14 Jul 1999 20:27:06 -0400 (EDT) To: Kyle Bateman cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] How big can a transaction query be? In-reply-to: Your message of Wed, 14 Jul 1999 17:03:12 -0600 <378D1730.F0809FF2@actarg.com> Date: Wed, 14 Jul 1999 20:27:06 -0400 Message-ID: <28611.931998426@sss.pgh.pa.us> From: Tom Lane Kyle Bateman writes: > As though it had lost track of the begin statement. It seems to fail > just as the total number of > characters in the query string passes 16K in size. I'm using the pgtcl > interface so the problem could > possibly be there as well. It sounds like you are sending the entire thing in a single query string and running into the limited size of the query input buffer. Execute the commands one at a time, or at least fewer at a time... regards, tom lane