Rod Taylor <[EMAIL PROTECTED]> writes:
> On Wed, 2002-09-18 at 11:03, Tom Lane wrote:
>> "Michael Paesold" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to