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!
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 |