Re: [HACKERS] Happy column dropping

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Happy column dropping
Дата
Msg-id 200001250251.VAA21667@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Happy column dropping  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] Happy column dropping  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] Happy column dropping  (Peter Eisentraut <e99re41@DoCS.UU.SE>)
Список pgsql-hackers
> "Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> > As far as I see,fixed mapping relname to relation filename is the
> > problem. This doesn't allow the coexistence of old and new relation
> > files.
> 
> Yes, and Vadim has proposed using relation OIDs as filenames for
> reasons of his own, IIRC.
> 
> If we did that we could also solve the problems we have now with
> rolling back table deletion/rename inside an aborted transaction.
> 
> I've been resisting this idea, but maybe it's time to bite the bullet
> and accept that relation filenames can't be the same as the logical
> names of the relations.
> 

Yes, that is going to happen, clearly.  New file names will be
table_name+oid.  Solves many problems.

New file name will not be just oid.  Too hard to administer.


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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Chris Bitmead
Дата:
Сообщение: Re: [HACKERS] Happy column dropping
Следующее
От: Mike Mascari
Дата:
Сообщение: Re: [HACKERS] DISTINCT ON: speak now or forever hold your peace