up vote 0 down vote favorite
share [g+] share [fb]

I have made some unfortunate UPDATE on a Postgresql table. Is it possible to reverse that change without any backup / rollback save etc?

link|improve this question
5  
yea start typing. – tony roth Oct 5 '11 at 13:47
1  
Y U NO BACKUP?? – GregD Oct 5 '11 at 14:11
feedback

2 Answers

up vote 2 down vote

NO. You've just moved to admin category which makes backups.

link|improve this answer
funny but not funny.... – tony roth Oct 5 '11 at 15:07
1  
+1 for learning the hard way – BoyMars Oct 5 '11 at 15:11
Im not an admin of that server :D If i were i would have a backup ;; – Gosu Oct 6 '11 at 6:49
feedback
up vote -2 down vote

You could restore it by dropping the table (make sure link from other tables aren't connected to it) and applying the SQL script that was created before you made the update. In other words, use the previous script and apply it. If you don't have a previous script, start writing it out so it is exactly the way the table was before you applied this 'unfortunate' update. Good luck!

link|improve this answer
Uhm.. A script usually creates the table scheme, not the data in the table.. – pauska Oct 5 '11 at 14:21
Why would you drop the whole table? – GregD Oct 5 '11 at 14:35
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.