> Hi everybody, > I was playing with psql and accidently deleted a couple of records from > my database. I am wondering if there is any way to restore them. I know > that in Oracle you can do 'rollback work' from SQLPlus interface and it > would rollback all the updates done to the database. That's available in PostgreSQL too. But, by entering psql autocommit is on by default, meaning every sql command is committed at once. To enable a rollback in psql you have to enter a transaction explicitly by using BEGIN; Everything done below BEGIN can be rolled back. Try.
> I am pretty sure that from now on I would try to revoke permissions to > delete anything from the database from users like myself. What is the > best way to do this? Refer to the sql commands GRANT and REVOKE within the documentation. Additionally, you should check the CREATE GROUP command. Creating groups of users is a very elegant way to grant/revoke permissions on objects. As far as I know there is no way to revoke delete permissions on the database as whole, you have to list all tables you want to have delete permissions dropped. Regards, Christoph ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
