From: | "Mark Hollomon" <mhh(at)nortelnetworks(dot)com> |
---|---|
To: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Big 7.1 open items |
Date: | 2000-06-15 12:28:12 |
Message-ID: | 3948CBDC.5A4F5705@americasm01.nt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Ross J. Reedstrom wrote:
>
> Any strong objections to the mixed relname_oid solution? It gets us
> everything oids does, and still lets Bruce use 'ls -l' to find the big
> tables, putting off writing any admin tools that'll need to be rewritten,
> anyway.
I would object to the mixed name.
Consider:
CREATE TABLE FOO ....
ALTER TABLE FOO RENAME FOO_OLD;
CREATE TABLE FOO ....
For the same atomicity reason, rename can't change the
name of the files. So, which foo_<oid> is the FOO_OLD
and which is FOO?
In other words, in the presence of rename, putting
relname in the filename is misleading at best.
--
Mark Hollomon
mhh(at)nortelnetworks(dot)com
ESN 451-9008 (302)454-9008
From | Date | Subject | |
---|---|---|---|
Next Message | Brian E Gallew | 2000-06-15 12:29:02 | Re: Big 7.1 open items |
Previous Message | The Hermit Hacker | 2000-06-15 12:14:29 | Re: Big 7.1 open items |
From | Date | Subject | |
---|---|---|---|
Next Message | Brian E Gallew | 2000-06-15 12:29:02 | Re: Big 7.1 open items |
Previous Message | The Hermit Hacker | 2000-06-15 12:14:29 | Re: Big 7.1 open items |