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