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

Re: [HACKERS] deadlock in REINDEX

2003-02-18 Thread Olleg Samoylov
S>message). GS> GS>Gavin It is incorrect. In PostgreSQL REINDEX must be routing (PostgreSQL 7.3.1 Documentation 8.3. Routine Reindexing). -- Olleg Samoylov ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unr

[HACKERS] New buildin function

2003-01-28 Thread Olleg Samoylov
On 23 Jan 2003, Rod Taylor wrote: RT>On Wed, 2003-01-22 at 08:09, Olleg Samoylov wrote: RT>> Hi! RT>> RT>> What about adding new function: RT>> pg_uid() RT>> pg_session_uid() RT>> RT>> as reference to internal function GetUserId() and GetSessionU

[HACKERS] New buildin function

2003-01-23 Thread Olleg Samoylov
Hi! What about adding new function: pg_uid() pg_session_uid() as reference to internal function GetUserId() and GetSessionUserId(). These can help useful, for instance in row based securety. -- Olleg Samoylov ---(end of broadcast)--- TIP 3: if