"zombie" table in psql

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
----------------------------------------------------------------------