"Rod Taylor" <rbt(at)zort(dot)ca> writes:
> 7.2 crashes with the below function:
> CREATE OR REPLACE FUNCTION runMaintenance()
> RETURNS BOOL AS '
> SELECT TRUE;
> ' LANGUAGE sql;
Ugh. The problem is that VACUUM's implicit CommitTransaction calls
wipe out all the transient memory allocated by the function evaluation.
I don't see any reasonable way to support VACUUM inside a function
call; I think we have to prohibit it.
Unfortunately I don't see any clean way to test for this situation
either. VACUUM's IsTransactionBlock() test obviously doesn't get the
job done. Any ideas how to catch this?
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2002-03-20 05:27:28|
|Subject: Re: [HACKERS] Fixes gram.y |
|Previous:||From: Christopher Kings-Lynne||Date: 2002-03-20 05:10:04|
|Subject: Help with SET NULL/SET NOT NULL|
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2002-03-22 04:22:58|
|Subject: Re: 7.2 crash... |
|Previous:||From: Robert E. Bruccoleri||Date: 2002-03-20 00:54:29|
|Subject: Re: Bug #612: PostgreSQL 7.2 does not build according to documentation under IRIX w/ MIPSpro |