Re: Thanks, naming conventions, and count()

Alfred Perlstein <bright@wintelcom.net>

From: Alfred Perlstein <bright@wintelcom.net>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: The Hermit Hacker <scrappy@hub.org>, Casey Lyon <casey@earthcars.com>, pgsql-hackers@postgresql.org
Date: 2001-04-30T03:17:28Z
Lists: pgsql-hackers
* Bruce Momjian <pgman@candle.pha.pa.us> [010429 20:14] wrote:

> Yes, I like that idea, but the problem is that it is hard to update just
> one table in the file.  You sort of have to update the entire file each
> time a table changes.  That is why I liked symlinks because they are
> per-table, but you are right that the symlink creation could fail
> because the new table file was never created or something, leaving the
> symlink pointing to nothing.  Not sure how to address this.  Is there a
> way to update a flat file when a single table changes?

Sort of, if that flat file is in the form of:
123456;"tablename                   "
000033;"another_table               "

ie, each line is a fixed length.


-- 
-Alfred Perlstein - [alfred@freebsd.org]
Daemon News Magazine in your snail-mail! http://magazine.daemonnews.org/