I've definitely seen errors from including vacuum and/or analyze
statements in functions, I think I've seen crashes too. If you check the
docs I'm pretty sure they mention the specifics of not being able to use
such statements.
Robert Treat
On Wed, 2002-09-18 at 04:09, Michael Paesold 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
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
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