Re: [SQL] How big can a transaction query be?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kyle Bateman <kyle(at)actarg(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] How big can a transaction query be?
Date: 1999-07-15 00:27:06
Message-ID: 28611.931998426@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kyle Bateman <kyle(at)actarg(dot)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

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-07-15 15:07:10 Re: [HACKERS] Counting bool flags in a complex query
Previous Message Kyle Bateman 1999-07-14 23:03:12 How big can a transaction query be?