Stored procedure array limits

Поиск
Список
Период
Сортировка
Искать
От
Paul B. Anderson
Тема
Stored procedure array limits
Дата
Msg-id
451C48AB.6090508@pnlassociates.com
Список
Дерево обсуждения
Stored procedure array limits "Paul B. Anderson" <paul.a@pnlassociates.com>
Re: Stored procedure array limits Tom Lane <tgl@sss.pgh.pa.us>
Re: Stored procedure array limits "Paul B. Anderson" <paul.a@pnlassociates.com>
Re: Stored procedure array limits "Paul B. Anderson" <paul.a@pnlassociates.com>
Array assignment behavior (was Re: Stored procedure array limits) Tom Lane <tgl@sss.pgh.pa.us>
Re: Array assignment behavior (was Re: Stored procedure array "Paul B. Anderson" <paul.a@pnlassociates.com>
Re: [GENERAL] Array assignment behavior (was Re: Stored procedure Erik Jones <erik@myemma.com>
Re: [GENERAL] Array assignment behavior (was Re: Stored procedure array limits) Casey Duncan <casey@pandora.com>
Re: [GENERAL] Array assignment behavior (was Re: Stored procedure array limits) "John D. Burger" <john@mitre.org>
Re: [GENERAL] Array assignment behavior (was Re: Stored procedure array limits) Tom Lane <tgl@sss.pgh.pa.us>
Re: [GENERAL] Array assignment behavior (was Re: Stored procedure Erik Jones <erik@myemma.com> 
I have a large stored procedure with 16 arrays, mostly varchar, each 
with dimension 3000.  The procedure works fine on a small number of rows 
used from these arrays but gets the following error for large rowsets:

  ERROR:  invalid array subscripts
  CONTEXT:  PL/pgSQL function "name_search" line 64 at assignment

I have not exceeded the size of the arrays, index-wise.

I increased max_stack_depth to 32768 and work_mem to 32768 but without 
effect.

If I comment out two particular arrays (that can have null values), it 
also runs OK.

Anybody have any ideas?

Paul
В списке pgsql-admin по дате отправления
Предыдущее
От: Sriram Dandapani
Дата:
Сообщение: autovacuum ignore tables
Следующее
От: Paul B. Anderson
Дата:
FAQ