Re: [BUGS] Out-of-Memory with ROWTYPE assignment in PL/pgSQL FOR loop

2005-06-20 Thread Bill Rugolsky Jr.
On Mon, Jun 20, 2005 at 06:54:20PM -0400, Tom Lane wrote: > "Bill Rugolsky Jr." <[EMAIL PROTECTED]> writes: > > The PL/pgSQL FOR loop in the function consume_memory() defined below > > will consume VM on each iteration until the process hits its ulimit. > > The problem occurs with variables of ROWT

Re: [BUGS] Out-of-Memory with ROWTYPE assignment in PL/pgSQL FOR loop

2005-06-20 Thread Tom Lane
"Bill Rugolsky Jr." <[EMAIL PROTECTED]> writes: > The PL/pgSQL FOR loop in the function consume_memory() defined below > will consume VM on each iteration until the process hits its ulimit. > The problem occurs with variables of ROWTYPE; there is no unbounded > allocation when using simple types su

[BUGS] Out-of-Memory with ROWTYPE assignment in PL/pgSQL FOR loop

2005-06-20 Thread Bill Rugolsky Jr.
Hello, The PL/pgSQL FOR loop in the function consume_memory() defined below will consume VM on each iteration until the process hits its ulimit. The problem occurs with variables of ROWTYPE; there is no unbounded allocation when using simple types such as integer or varchar. Before I delve into t