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@virtual.org.uk
U-NET Internet Noc Some day now!