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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [SQL] How big can a transaction query be?
Дата
Msg-id 28611.931998426@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How big can a transaction query be?  (Kyle Bateman <kyle@actarg.com>)
Список 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 по дате отправления:

Предыдущее
От: Kyle Bateman
Дата:
Сообщение: How big can a transaction query be?
Следующее
От: "Esteban Chiner Sanz"
Дата:
Сообщение: Foreign keys