Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id f9Q0QQP27832
	for <pgsql-sql@postgresql.org>; Thu, 25 Oct 2001 20:26:26 -0400 (EDT)
	(envelope-from olebedev@waterford.org)
Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org
	(Netscape Messaging Server 3.56)  with ESMTP id 476
	for <pgsql-sql@postgresql.org>; Thu, 25 Oct 2001 18:16:23 -0600
Message-ID: <3BD8B22F.AA385530@waterford.org>
Date: Thu, 25 Oct 2001 18:45:35 -0600
From: Oleg Lebedev <olebedev@waterford.org>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Postgres SQL Mailing List <pgsql-sql@postgresql.org>
Subject: rollback
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200110/364
X-Sequence-Number: 5317

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.
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?
thanks,

Oleg