Re: [HACKERS] Happy column dropping - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Happy column dropping
Date
Msg-id 11596.948772804@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Happy column dropping  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Happy column dropping
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> New file name will not be just oid.  Too hard to administer.

But if it contains the table name, you still have the problem we'd
like to avoid: renaming the file(s) is a critical part of committing
a table-renaming transaction.

The debugging and administrative convenience of using table names as
filenames is exactly why we've resisted this for so long.  But I am
starting to think that we have to give that up.  It's nice, but
having robust DDL commands is nicer.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Happy column dropping
Next
From: Chairudin Sentosa Harjo
Date:
Subject: Cannot flush block 9782