Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Date
Msg-id 199911290513.AAA05829@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions  ("Mike Mascari" <mascarm@mascari.com>)
List pgsql-hackers
> if PostgreSQL could successfully rollback DDL statements sanely (and thus
> diverge from ORACLE). I guess I don't expect that to happen successfully
> until
> something the equivalent of TABLESPACES is implemented and there is a
> disassociation between table names, index names and their filesystem
> counterparts and to be able to "undo" filesystem operations. That, it seems
> to
> me, will be a major undertaking and not going to happen any time soon...

Ingres has table names that don't match on-disk file names, and it is a
pain to administer because you can't figure out what is going on at the
file system level.  Table files have names like AAAHFGE.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re:
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] How to get OID from INSERT in PL/PGSQL?