Received: from www.actarg.com (root@[209.180.91.25]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA07292 for ; Wed, 14 Jul 1999 18:57:53 -0400 (EDT) (envelope-from kyle@actarg.com) Received: from actarg.com (root@tao.actarg.com [192.168.1.1]) by www.actarg.com (8.8.7/8.8.7) with ESMTP id RAA14716 for ; Wed, 14 Jul 1999 17:00:56 -0600 Received: from actarg.com (kyle@chi.actarg.com [192.168.2.16]) by actarg.com (8.8.7/8.8.7) with ESMTP id QAA16089 for ; Wed, 14 Jul 1999 16:55:36 -0600 Sender: kyle@actarg.com Message-ID: <378D1730.F0809FF2@actarg.com> Date: Wed, 14 Jul 1999 17:03:12 -0600 From: Kyle Bateman Organization: Action Target Inc X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: How big can a transaction query be? Content-Type: multipart/alternative; boundary="------------78F351580E34ACC65F58657A" --------------78F351580E34ACC65F58657A Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Is there some limit to the size of a query or the number of independent queries that may be done inside a transaction? I'm doing something that looks like this: begin; grant select on vend to spence; grant select on cont to spence; grant select on privs to spence; grant insert,select,update on cont to susan; grant insert,select,update on cont_event to susan; grant select,update on cont_seq to susan; grant select on privs to susan; grant delete,insert,select,update on po_hdr to teague; grant delete,insert,select,update on empl to teague; grant select,update on equ_seq to teague; grant delete,insert,select,update on empl_event to teague; grant select on prd_parm to teague; grant select on prd_part to teague; grant select,update on empl_seq to teague; grant delete,insert,select,update on mtr_reg to teague; grant select on prd_base to teague; grant select on prd_vend to teague; end; (or abort;) But it goes on for several hundred such lines. It works great until it gets too long and then I get: NOTICE: UserAbortTransactionBlock and not in in-progress state 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. Does anyone know what this limitation is and if it can be tweaked to be higher without a major amount of hassle? (unlimited would be nice :) -- ---------------------------------------------------- Kyle Bateman President, Action Target Inc. "Viva Yo!" kyle@actarg.com (801)377-8033x101 ---------------------------------------------------- --------------78F351580E34ACC65F58657A Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit  
Is there some limit to the size of a query or the number of independent queries that may be done
inside a transaction?

I'm doing something that looks like this:

begin;
grant select on vend to spence;
grant select on cont to spence;
grant select on privs to spence;
grant insert,select,update on cont to susan;
grant insert,select,update on cont_event to susan;
grant select,update on cont_seq to susan;
grant select on privs to susan;
grant delete,insert,select,update on po_hdr to teague;
grant delete,insert,select,update on empl to teague;
grant select,update on equ_seq to teague;
grant delete,insert,select,update on empl_event to teague;
grant select on prd_parm to teague;
grant select on prd_part to teague;
grant select,update on empl_seq to teague;
grant delete,insert,select,update on mtr_reg to teague;
grant select on prd_base to teague;
grant select on prd_vend to teague;
end; (or abort;)

But it goes on for several hundred such lines.  It works great until it gets too long and then I get:

NOTICE:  UserAbortTransactionBlock and not in in-progress state

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.

Does anyone know what this limitation is and if it can be tweaked to be higher without a major
amount of hassle?  (unlimited would be nice :)

-- 
 ----------------------------------------------------
 Kyle Bateman       President, Action Target Inc.
 "Viva Yo!"         kyle@actarg.com (801)377-8033x101
 ----------------------------------------------------
  --------------78F351580E34ACC65F58657A--