| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Ron Snyder <snyder(at)roguewave(dot)com>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Open 7.3 items |
| Date: | 2002-08-08 03:30:37 |
| Message-ID: | 1028777437.2123.7.camel@rh72.home.ee |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 2002-08-08 at 07:31, Tom Lane wrote:
> Hannu Krosing <hannu(at)tm(dot)ee> writes:
> > On Thu, 2002-08-08 at 03:27, Marc G. Fournier wrote:
> >> Actually, I kinda like dbname.username myself ... it means that wne you do
> >> a SELECT of the pg_shadow file, it can be sorted in a useful manner (ie.
> >> grouped by database)
>
> Hmm, Marc's got a point there...
>
> > use a view :
>
> Yeah, but it's painful to do that.
Not if the view is installed with the system.
So the plan could be:
1 .give the new functionality in a "light" version - ie just checking at
connect time, full name must be used when creating user.
2. modify pg_user to show it usename usedomain as two separate fields
for eas of use (join pg_user and pg_shadow on usesysid if you need to
see passwords)
3. in version 7.4 modify CREATE USER and ALTER USER to save the domain
info in pg_shadow.usedomain.
-----------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J. R. Nield | 2002-08-08 03:31:35 | Re: PITR, checkpoint, and local relations |
| Previous Message | Tom Lane | 2002-08-08 03:25:52 | Re: Proposal: stand-alone composite types |