Re: [HACKERS] Happy column dropping

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Cc: "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "The Hermit Hacker" <scrappy(at)hub(dot)org>, "PostgreSQL Development" <pgsql-hackers(at)postgreSQL(dot)org>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Subject: Re: [HACKERS] Happy column dropping
Date: 2000-01-25 00:25:43
Message-ID: 27422.948759943@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alfred Perlstein 2000-01-25 01:30:49 Re: [HACKERS] Re: pg_dump possible fix, need testers.
Previous Message Hiroshi Inoue 2000-01-25 00:21:15 RE: [HACKERS] Happy column dropping