From: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
---|---|
To: | Pierre Racine <racine_pierre(at)hotmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: HELP - Recover function delete |
Date: | 2005-09-19 14:44:24 |
Message-ID: | 432ECEC8.80601@pse-consulting.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Pierre Racine wrote:
> Hi,
>
> I just hit twice the delete button on a function I spent two days
> writing (without backing it up. I know... I know...). Is there a way
> to recover it?
Ahm, there's the security question, which asks for confirmation (which
may be disabled for people like me who newwer pressss da wrong kay :-)
A dropped object is dropped, but (as any row in a table) is still
physically present until VACUUMed. In theory, the XID could be tuned
back (by hacking the kernel), but I doubt it's worth the trouble.
>
> A simple garbage would do the job. I don't know many software now that
> do not implement a sort of simple mecanism to recover what we threw
> away by mistake...
Not this kind of stuff. The object tree is not an editor, but a
structured view of database content. We're executing "DROP FUNCTION
dontDropMe()" and that's it.
Happy recoding...
Regards,
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Diego Gil | 2005-09-19 19:19:56 | Re: wrong order of drop ... create ... sentences |
Previous Message | Pierre Racine | 2005-09-19 13:39:47 | HELP - Recover function delete |