From: | "Jose' Soares Da Silva" <sferac(at)proxy(dot)bazzanese(dot)com> |
---|---|
To: | "Meskes, Michael" <meskes(at)topsystem(dot)de> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org, pgsq-bugs(at)postgreSQL(dot)org, sferac(at)bo(dot)nettuno(dot)it |
Subject: | RE: [HACKERS] drop table inside transactions |
Date: | 1998-04-17 17:05:08 |
Message-ID: | Pine.LNX.3.96.980417164747.1733A-100000@proxy.bazzanese.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, 17 Apr 1998, Meskes, Michael wrote:
> Is this really a bug? I haven't seen any (commercial) system supporting
> this kind of transaction recovery. Once you drop a table the data is
> lost, no matter if you rollback or not.
>
> Michael
Maybe you are right Michael, but there's another point; the table wasn't
removed, it is still there, only data are cancelled.
It's more, like a DELETE FROM ... not a DROP TABLE...
and, if another user inserts data into this dropped table,
the table returns with all data.
(Refer to my first bug-report on this matter),
and more; some times ROLLBACK restores both data and table structure. ;-)
>
> > prova=> drop table a;
> > DROP
> > prova=> select * from a;
> > ERROR: a: Table does not exist.
> > prova=> rollback;
> > ABORT
> > prova=> select * from a;
> > a
> > -
> > (0 rows)
> > Jose'
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1998-04-17 17:05:37 | Proposal for async support in libpq |
Previous Message | Bruce Momjian | 1998-04-17 14:48:08 | Re: [HACKERS] drop table inside transactions |