Re: Backend crash (long) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Backend crash (long)
Date
Msg-id 17981.1032362127@sss.pgh.pa.us
Whole thread Raw
In response to Re: Backend crash (long)  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
Rod Taylor <rbt@rbt.ca> writes:
> On Wed, 2002-09-18 at 11:03, Tom Lane wrote:
>> "Michael Paesold" <mpaesold@gmx.at> writes:
> I have written a test function, that will create a sequence and a table,
> than insert one million rows into the table, analyze the table and create an
> index on one of the columns.
>> 
>> You can't run ANALYZE inside a function.  In CVS tip there's a check to
>> prevent the VACUUM variant of this problem, but I'm not sure if it
>> handles the ANALYZE variant (yet).

> ANALYZE in 7.3 works fine in a transaction, so it shouldn't it be able
> to work in a function as well?

Possibly it's okay in 7.3; I have a note to look at that, but haven't
done it yet.  I think REINDEX has the same problem btw ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: The notorious to_char bug
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Proposal for resolving casting issues