pl/pgsql and backend crashes

From: Paul Kelly <pkelly(at)virtual(dot)org(dot)uk>
To: pgsql-general(at)hub(dot)org
Subject: pl/pgsql and backend crashes
Date: 1999-10-12 09:14:15
Message-ID: Pine.LNX.4.10.9910121008090.8490-100000@virtual.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,
i seem to be experienceing a problem where after updating an existing
pl/pgsql function the backend crashes. the function code is ok, if i
restart the backend and then vcaccum it usually will create the function
and work fine. if i create a new function it will usually go through quite
a few changes to the function before this problem starts to occur, its
almost as if something is filling up.

its not a great problem, more of an annoyance as i really need to have as
little downtime as possible. is there some sort of index i can recreate or
something to stop this from happening?

i really find pl/pgsql useful and hope it gets more development.

im using postgres:

PostgreSQL 6.5.0 on sparc-sun-solaris2.7, compiled by gcc egcs-2.91.60

thanks
Paul
----------------------------------------------
Paul Kelly pkelly(at)virtual(dot)org(dot)uk
U-NET Internet Noc Some day now!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message greg 1999-10-12 10:56:38 How to read system variables like datestyle, etc...
Previous Message The Hermit Hacker 1999-10-12 04:02:49 Re: [HACKERS] Re: [GENERAL] Update of bitmask type