Re: [SQL] How big can a transaction query be? - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] How big can a transaction query be?
Date
Msg-id 28611.931998426@sss.pgh.pa.us
Whole thread Raw
In response to How big can a transaction query be?  (Kyle Bateman <kyle@actarg.com>)
List 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


pgsql-sql by date:

Previous
From: Kyle Bateman
Date:
Subject: How big can a transaction query be?
Next
From: "Esteban Chiner Sanz"
Date:
Subject: Foreign keys