From: | Ulf Mehlig <umehlig(at)uni-bremen(dot)de> |
---|---|
To: | jim(at)reptiles(dot)org |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] dropping a table, leaving actual file in base/db/... |
Date: | 1999-03-11 07:54:34 |
Message-ID: | 199903110754.IAA01893@pandora3.uni-bremen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
jim(at)reptiles(dot)org (Jim Mercer) wrote:
> begin work;
> select * into tmptable from main table;
> commit work;
> drop table tmptable;
>
> sometimes (always?) tmptable gets dropped from the database, but for
> some reason the file /usr/pgsql/data/base/dbname/tmptable does not get
> deleted.
I think I posted something similar some time ago, didn't get a reply:
Ulf Mehlig <umehlig(at)uni-bremen(dot)de>:
> 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?
The very last line (giving \dt command) I can't reproduce at the
moment.
Ciao, Ulf
--
======================================================================
Ulf Mehlig <umehlig(at)zmt(dot)uni-bremen(dot)de>
Center for Tropical Marine Ecology/ZMT, Bremen, Germany
----------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel PaJaSoft Janousek | 1999-03-11 08:13:39 | Re: [GENERAL] Is it possible to change a columns name |
Previous Message | Valerio Santinelli | 1999-03-11 01:44:49 | Re: [GENERAL] question on converting M$ Access tables |