<br />Is there some limit to the size of a query or the number of independent queries that may be done <br />inside
atransaction? <p>I'm doing something that looks like this: <p><tt>begin;</tt><br /><tt>grant select on vend to
spence;</tt><br/><tt>grant select on cont to spence;</tt><br /><tt>grant select on privs to spence;</tt><br /><tt>grant
insert,select,updateon cont to susan;</tt><br /><tt>grant insert,select,update on cont_event to susan;</tt><br
/><tt>grantselect,update on cont_seq to susan;</tt><br /><tt>grant select on privs to susan;</tt><br /><tt>grant
delete,insert,select,updateon po_hdr to teague;</tt><br /><tt>grant delete,insert,select,update on empl to
teague;</tt><br/><tt>grant select,update on equ_seq to teague;</tt><br /><tt>grant delete,insert,select,update on
empl_eventto teague;</tt><br /><tt>grant select on prd_parm to teague;</tt><br /><tt>grant select on prd_part to
teague;</tt><br/><tt>grant select,update on empl_seq to teague;</tt><br /><tt>grant delete,insert,select,update on
mtr_regto teague;</tt><br /><tt>grant select on prd_base to teague;</tt><br /><tt>grant select on prd_vend to
teague;</tt><br/><tt>end; (or abort;)</tt><p>But it goes on for several hundred such lines. It works great until it
getstoo long and then I get: <p><tt>NOTICE: UserAbortTransactionBlock and not in in-progress state</tt><p>As though it
hadlost track of the begin statement. It seems to fail just as the total number of <br />characters in the query
stringpasses 16K in size. I'm using the pgtcl interface so the problem could <br />possibly be there as well. <p>Does
anyoneknow what this limitation is and if it can be tweaked to be higher without a major <br />amount of hassle?
(unlimitedwould be nice :) <pre>--
----------------------------------------------------
Kyle Bateman President, Action Target Inc.
"Viva Yo!" kyle@actarg.com (801)377-8033x101
----------------------------------------------------</pre>
