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@nortelnetworks.com
ESN 451-9008 (302)454-9008