From: | Kyle Bateman <kyle(at)actarg(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | How big can a transaction query be? |
Date: | 1999-07-14 23:03:12 |
Message-ID: | 378D1730.F0809FF2@actarg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)actarg(dot)com (801)377-8033x101
----------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-07-15 00:27:06 | Re: [SQL] How big can a transaction query be? |
Previous Message | Evan Klinger | 1999-07-14 21:05:00 | SELECT using arrays |