Re: Function Vanished

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 version, but if I can get the debugged
version back ...

> 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 need. But if it's more than a couple K
> then the text will be compressed and difficult to spot or extract.

Can you explain that? I think that the text may be short entough to be
uncompressed.

-Josh Berkus

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