Skip site navigation (1) Skip section navigation (2)

Re: Thanks, naming conventions, and count()

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Casey Lyon <casey(at)earthcars(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Thanks, naming conventions, and count()
Date: 2001-04-30 02:56:28
Message-ID: Pine.BSF.4.33.0104292351060.411-100000@mobile.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sun, 29 Apr 2001, Bruce Momjian wrote:

> >
> > doesn't this defeat the reasons for going to numerics?  is there a reason
> > why its such a difficult thing to do a SELECT oid on pg_database and
> > pg_class to get this information?  that's what I've been doing when I need
> > to know *shrug*
>
> Yes, but you can't do that if you can't start the database or can't
> connect for some reason.  If people don't think it is worthwhile, we can
> delete the TODO item.

Okay, what does being able to ls the directory give you if you can't start
the database?  the only thing I do it for is to figure out whicih tables
are taking up so much disk space, or which databases ...

> For example, when someone has trouble figuring out which directory is
> which database, they can just ls and look at the symlinks.  Seems like
> a nice feature.

Ya, but I thought that the reason for going numeric had to do with being
transaction safe ... something about being able to safely RENAME a table,
if my recollection remotely comes close ... as soon as you start throwing
around symlinks, do we break that once more?  what about if someone wants
to physically move a table to a seperate file system, which is something
that has been suggested as a way around the fact that all files are in the
same subdirectory?  You have a symlink to the symlink?

I don't know the answers to these questions, which is why I'm asking them
... if this is something safe to do, and doesn't break us again, then
sounds like a good idea to me too ...


In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-04-30 03:00:00
Subject: Re: Thanks, naming conventions, and count()
Previous:From: Bruce MomjianDate: 2001-04-30 02:51:22
Subject: Re: Thanks, naming conventions, and count()

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group