From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Peter Eisentraut" <peter_e(at)gmx(dot)net> |
Cc: | "Jan Wieck" <JanWieck(at)Yahoo(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Bruce Momjian" <maillist(at)candle(dot)pha(dot)pa(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>, "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | RE: Big 7.1 open items |
Date: | 2000-06-20 23:54:51 |
Message-ID: | 000e01bfdb12$ecc08f00$2801007e@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
> -----Original Message-----
> From: Peter Eisentraut
>
> Bruce Momjian writes:
>
> > If we have a new CREATE DATABASE LOCATION command, we can say:
> >
> > CREATE DATABASE LOCATION dbloc IN '/var/private/pgsql';
> > CREATE DATABASE newdb IN dbloc;
>
> We kind of have this already, with CREATE DATABASE foo WITH LOCATION =
> 'bar'; but of course with environment variable kludgery. But it's a start.
>
> > mkdir /var/private/pgsql/dbloc
> > ln -s /var/private/pgsql/dbloc data/base/dbloc
>
> I think the problem with this was that you'd have to do an extra lookup
> into, say, pg_location to resolve this. Some people are talking about
> blind writes, this is not really blind.
>
> > CREATE LOCATION tabloc IN '/var/private/pgsql';
> > CREATE TABLE newtab ... IN tabloc;
>
> Okay, so we'd have "table spaces" and "database spaces". Seems like one
> "space" ought to be enough.
Does your "database space" correspond to current PostgreSQL's database ?
And is it different from SCHEMA ?
Regards.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp
From | Date | Subject | |
---|---|---|---|
Next Message | Philip J. Warner | 2000-06-21 01:22:10 | RE: Big 7.1 open items |
Previous Message | Ryan Kirkpatrick | 2000-06-20 23:15:25 | Re: [HACKERS] Re: Call for port testing on fmgr changes -- Results! |
From | Date | Subject | |
---|---|---|---|
Next Message | Philip J. Warner | 2000-06-21 01:22:10 | RE: Big 7.1 open items |
Previous Message | Hiroshi Inoue | 2000-06-20 20:59:41 | RE: Big 7.1 open items |