Thanks for replyin buddy I had a partial backup and recovered from that will take care next time thanks again > You can not rollback a committed transaction. > > Time to restore some backups - what kind of backup are you using? > > ~p > > On Sat, 2007-03-17 at 16:19 +0530, Hetal Patel wrote: > >> Hello Friends >> New to postgresql >> I m in trouble >> I fired a query a "DELETE" query from a PGADMIN III postgresql tool >> Which have deleted some rows which shud ve not been deleted >> How do i get it rollback >> I mean i want all the rows back >> Please help me >> Its urgent >> Thanks in advance for Help >> >> >> Hetal Patel >> System Dept. >> Banasdairy >> > > > *******************Confidentiality and Privilege Notice******************* > > The material contained in this message is privileged and confidential to > the addressee. If you are not the addressee indicated in this message or > responsible for delivery of the message to such person, you may not copy > or deliver this message to anyone, and you should destroy it and kindly > notify the sender by reply email. > > Information in this message that does not relate to the official business > of Weatherbeeta must be treated as neither given nor endorsed by > Weatherbeeta. > Weatherbeeta, its employees, contractors or associates shall not be liable > for direct, indirect or consequential loss arising from transmission of > this > message or any attachments > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > >
Hetal Patel System Dept. Banasdairy -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match