Re: PG 7.2.1 core dump

On Wed, 2002-08-14 at 15:58, Tom Jenkins wrote:
> Hey folks,
> While testing out a function that does updates on one of our databases,
> i got a sig 11.  the same script ran fine on another machine, so it may
> be hardware related.  oh wait, this is the script that changed to a
> function; i believe i ran it as a script on the other machine - so it
> may not be hardware related.
>

This triggered a thought.  The script had ANALYZE statements.  they were
not removed when converted to a function.  i removed these ANALYZE
statements and the function ran.

So looks like in pl/pgsql if you have ANALYZE statements you can
(possibly) crash the server.

--

Tom Jenkins
Development InfoStructure
http://www.devis.com