From: Kyle Bateman <kyle@actarg.com>
To: pgsql-sql@postgresql.org
Subject: How big can a transaction query be?
Date: Wed, 14 Jul 1999 17:03:12 -0600
Message-ID: <378D1730.F0809FF2@actarg.com> (raw)
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
----------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: kyle@actarg.com
Subject: Re: How big can a transaction query be?
In-Reply-To: <378D1730.F0809FF2@actarg.com>
References: <378D1730.F0809FF2@actarg.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox