pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow big can a transaction query be?
2+ messages / 2 participants
[nested] [flat]
* How big can a transaction query be?
@ 1999-07-14 23:03 Kyle Bateman <kyle@actarg.com>
0 siblings, 1 reply; 2+ messages in thread
From: Kyle Bateman @ 1999-07-14 23:03 UTC (permalink / raw)
To: 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@actarg.com (801)377-8033x101
----------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] How big can a transaction query be?
@ 1999-07-15 00:27 Tom Lane <tgl@sss.pgh.pa.us>
parent: Kyle Bateman <kyle@actarg.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 1999-07-15 00:27 UTC (permalink / raw)
To: Kyle Bateman <kyle@actarg.com>; +Cc: pgsql-sql
Kyle Bateman <kyle@actarg.com> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1999-07-15 00:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-14 23:03 How big can a transaction query be? Kyle Bateman <kyle@actarg.com>
1999-07-15 00:27 ` Tom Lane <tgl@sss.pgh.pa.us>
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