Function Vanished - Mailing list pgsql-sql

From Josh Berkus
Subject Function Vanished
Date
Msg-id web-30035@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Calling Java from psql (was Re: requesting help)  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Function Vanished
List pgsql-sql
Tom, Jan,
I've already contacted PGSQL Inc. support about this, but I thought
that you might have some immediate insight.
I'm using 7.1 Beta 3, which has been pretty stable up until now.  This
morning, I went to export a function I spent 5 hours debugging on on
Friday to text so that I could have a copy of the final version.  To my
horror, the function was GONE from the system catalog (pg_proc).  I have
not run VACUUM on the database anytime recently ... is there any
possibility that my function is still present as a "deleted" row?

-Josh Berkus


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: wade
Date:
Subject: pl/pgsql and returning rows
Next
From: Stephen Jackson
Date:
Subject: Implicit/Explicit casting of the unknown type