pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedSESSION_USER
6+ messages / 3 participants
[nested] [flat]
* SESSION_USER
@ 2000-04-14 20:35 Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Bruce Momjian @ 2000-04-14 20:35 UTC (permalink / raw)
To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>; PostgreSQL-documentation <docs@postgreSQL.org>
create_table.sgml mentions SESSION_USER is not supported. I don't think
that is true anymore, is it?
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: [HACKERS] SESSION_USER
@ 2000-04-14 21:30 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2000-04-14 21:30 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>; PostgreSQL-documentation <docs@postgreSQL.org>
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> create_table.sgml mentions SESSION_USER is not supported. I don't think
> that is true anymore, is it?
regression=# select session_user;
getpgusername
---------------
postgres
(1 row)
Looking at the spec, we do seem to be missing SYSTEM_USER out of the
four variants the spec mentions. However, considering that we map
them all to the same thing anyway, I can't get too excited about it.
If something is done about making functions have setuid-like behavior,
we'd want to make sure that the appropriate ones of these functions
change value inside a function.
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: [HACKERS] SESSION_USER
@ 2000-04-15 18:50 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 6+ messages in thread
From: Bruce Momjian @ 2000-04-15 18:50 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; PostgreSQL-development <pgsql-hackers@postgreSQL.org>; PostgreSQL-documentation <docs@postgreSQL.org>
[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> Tom Lane writes:
>
> > Looking at the spec, we do seem to be missing SYSTEM_USER out of the
> > four variants the spec mentions. However, considering that we map
> > them all to the same thing anyway, I can't get too excited about it.
>
> SYSTEM_USER is the operating system user that connected to the database
> system. This is obviously not generally applicable in the environment
> PostgreSQL runs in, nor is there a universal and reliable way to get this
> information, so I suggest we don't bother about it. Mapping it to
> [CURRENT_]USER would certainly be wrong.
>
Well, we do already map it. I just documented it.
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: [HACKERS] SESSION_USER
@ 2000-04-15 18:53 Peter Eisentraut <peter_e@gmx.net>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Peter Eisentraut @ 2000-04-15 18:53 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; PostgreSQL-development <pgsql-hackers@postgresql.org>; PostgreSQL-documentation <docs@postgresql.org>
Tom Lane writes:
> Looking at the spec, we do seem to be missing SYSTEM_USER out of the
> four variants the spec mentions. However, considering that we map
> them all to the same thing anyway, I can't get too excited about it.
SYSTEM_USER is the operating system user that connected to the database
system. This is obviously not generally applicable in the environment
PostgreSQL runs in, nor is there a universal and reliable way to get this
information, so I suggest we don't bother about it. Mapping it to
[CURRENT_]USER would certainly be wrong.
--
Peter Eisentraut Sernanders väg 10:115
peter_e@gmx.net 75262 Uppsala
http://yi.org/peter-e/ Sweden
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: [HACKERS] SESSION_USER
@ 2000-04-15 22:52 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Tom Lane @ 2000-04-15 22:52 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; PostgreSQL-development <pgsql-hackers@postgresql.org>; PostgreSQL-documentation <docs@postgresql.org>
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> SYSTEM_USER is the operating system user that connected to the database
>> system. This is obviously not generally applicable in the environment
>> PostgreSQL runs in, nor is there a universal and reliable way to get this
>> information, so I suggest we don't bother about it. Mapping it to
>> [CURRENT_]USER would certainly be wrong.
> Well, we do already map it. I just documented it.
No we don't!
regression=# select system_user;
ERROR: Attribute 'system_user' not found
regards, tom lane
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Re: [HACKERS] SESSION_USER
@ 2000-04-15 23:28 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2000-04-15 23:28 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; PostgreSQL-development <pgsql-hackers@postgresql.org>; PostgreSQL-documentation <docs@postgresql.org>
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >> SYSTEM_USER is the operating system user that connected to the database
> >> system. This is obviously not generally applicable in the environment
> >> PostgreSQL runs in, nor is there a universal and reliable way to get this
> >> information, so I suggest we don't bother about it. Mapping it to
> >> [CURRENT_]USER would certainly be wrong.
>
> > Well, we do already map it. I just documented it.
>
> No we don't!
>
> regression=# select system_user;
> ERROR: Attribute 'system_user' not found
Updated. Thanks.
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2000-04-15 23:28 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-04-14 20:35 SESSION_USER Bruce Momjian <pgman@candle.pha.pa.us>
2000-04-14 21:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-04-15 18:53 ` Peter Eisentraut <peter_e@gmx.net>
2000-04-15 18:50 ` Bruce Momjian <pgman@candle.pha.pa.us>
2000-04-15 22:52 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-04-15 23:28 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox