"zombie" table in psql - Mailing list pgsql-general

From Ulf Mehlig
Subject "zombie" table in psql
Date
Msg-id 199901201802.TAA02932@uni-bremen.de
Whole thread Raw
List 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@zmt.uni-bremen.de>
              Center for Tropical Marine Ecology/ZMT, Bremen, Germany
----------------------------------------------------------------------

pgsql-general by date:

Previous
From: "PostgreSQL"
Date:
Subject: Maximum execution time exceeded
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] {OT} Maximum execution time exceeded