Hi would it work to do a pg_dump -d or a pgdumpall, then look through
the dumped sql file?
I do that to retrieve PL/pgSQL functions from the database when I've
accidentally wiped or modified the source (not often, but it happens).
Regards and best wishes,
Justin Clift
Tom Lane wrote:
>
> "Jos
"Josh Berkus" <[EMAIL PROTECTED]> writes:
>> Should still be there in the table, if you haven't vacuumed. Getting
>> it out again is another story though. If it was a small enough
>> function,
>> good ol' "strings" would do to extract the function body, which is
>> probably all that you really n
Tom,
> Ick. Were you maybe working on it inside a transaction that you
> forgot
> to commit?
Nope. Friday was debugging work; the function had already been saved as
a buggy version. I can even find the last buggy call to the function,
on Friday, in the logs.
I do have a copy of the buggy ver
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> 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
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
