From: | Ulf Mehlig <umehlig(at)uni-bremen(dot)de> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | "zombie" table in psql |
Date: | 1999-01-20 17:51:55 |
Message-ID: | 199901201802.TAA02932@uni-bremen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello everybody!
Consider this (psql of 6.4, on i386-Linux 2.02b7):
db=> begin work;
BEGIN
db=> create table xxx (xx smallint);
CREATE
db=> insert into xxx values (1);
INSERT 136937 1
db=> rollback;
ABORT
The following is interesting:
db=> select * from xxx;
ERROR: xxx: Table does not exist.
db=> create table xxx (xx smallint);
ERROR: xxx relation already exists
Hmmm. And then:
db=> drop table xxx;
ERROR: Relation xxx Does Not Exist!
db=> \dt
NOTICE: (transaction aborted): queries ignored until END
Couldn't find any tables!
After quitting and re-entering psql it is possible again to create a
table "xxx". Seems to be a little bug, or did I overlook something?
BTW, is ist possible to get "nested" transactions (e.g., to realize a
multilevel "undo" in data entry forms)?
Thanks,
Ulf
--
======================================================================
Ulf Mehlig <umehlig(at)zmt(dot)uni-bremen(dot)de>
Center for Tropical Marine Ecology/ZMT, Bremen, Germany
----------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1999-01-20 18:38:51 | RE: [GENERAL] {OT} Maximum execution time exceeded |
Previous Message | PostgreSQL | 1999-01-20 17:24:59 | Maximum execution time exceeded |