Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mike Mascari <mascarm(at)mascari(dot)com>
Cc: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Lincoln Yeoh <lylyeoh(at)mecomb(dot)com>, pgsql-general(at)postgreSQL(dot)org, PostgreSQL Developers List <hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Date: 1999-11-29 05:13:59
Message-ID: 199911290513.AAA05829@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1999-11-29 05:20:13
Subject: Re: [HACKERS] Re:
Previous:From: Tom LaneDate: 1999-11-29 05:13:10
Subject: Re: [HACKERS] Re: Concurrent VACUUM: first results

pgsql-general by date

Next:From: Vadim MikheevDate: 1999-11-29 05:59:22
Subject: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Previous:From: John HendersonDate: 1999-11-29 05:11:59
Subject: memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group