Re: [HACKERS] function to return pg_user.usesysid

2003-02-18 Thread Olleg Samoylov
Hi all, Also need add function, returned GetSessionUserId() too. On 7 Feb 2003, Dr. Ernst Molitor wrote: DEM>record offers saving a few bytes per record, so I wrote a _very small_ DEM>add-on to directly access the usesysid information, using the function DEM>GetUserId(). -- Olleg Samoylov --

Re: [HACKERS] function to return pg_user.usesysid

2003-02-08 Thread Kevin Brown
Neil Conway wrote: > On Fri, 2003-02-07 at 07:03, Dr. Ernst Molitor wrote: > > Hm, by the way, what about adding a function like current_userid to the > > core functionality of PostgreSQL? > > What exactly would this do that couldn't be done by just querying > pg_user directly? > > SELECT usesysi

Re: [HACKERS] function to return pg_user.usesysid

2003-02-07 Thread Neil Conway
On Fri, 2003-02-07 at 07:03, Dr. Ernst Molitor wrote: > Hm, by the way, what about adding a function like current_userid to the > core functionality of PostgreSQL? What exactly would this do that couldn't be done by just querying pg_user directly? SELECT usesysid FROM pg_user WHERE usename = CURR

[HACKERS] function to return pg_user.usesysid

2003-02-07 Thread Dr. Ernst Molitor
Dear PostgreSQL developers, as far as I know, there is no function available to directly access the user id (pg_(shadow|user).usesysid) of the current database user, while the user's name is easily available (function current_user). For a couple of databases I'm using or designing, it is neces