Re: [GENERAL] Connected user in a triggerfunction

2006-01-26 Thread Dick Kniep
Oops, Sorry, didn't get the answers untill just now... Op donderdag 26 januari 2006 10:02, schreef Richard Huxton: > Dick Kniep wrote: > > Anyone? > > I thought I saw an answer to this yesterday. Have you tried CURRENT_USER > ? It's in the "functions and operators" section of the manuals (contrary

Re: [GENERAL] Connected user in a triggerfunction

2006-01-26 Thread Richard Huxton
Dick Kniep wrote: Anyone? I thought I saw an answer to this yesterday. Have you tried CURRENT_USER ? It's in the "functions and operators" section of the manuals (contrary to appearance, it is a function). Op vrijdag 20 januari 2006 07:56, schreef Dick Kniep: Hi list, We are using loggin

Re: [GENERAL] Connected user in a triggerfunction

2006-01-26 Thread Dick Kniep
Anyone? Op vrijdag 20 januari 2006 07:56, schreef Dick Kniep: > Hi list, > > We are using logging in a database based on triggers and plpgsql functions. > This works OK. However, we want deletes to be recorded too, and there we > want the user who connected to be recorded in the log. So, how can I

Re: [GENERAL] Connected user in a triggerfunction

2006-01-19 Thread Michael Fuhr
On Fri, Jan 20, 2006 at 07:56:38AM +0100, Dick Kniep wrote: > We are using logging in a database based on triggers and plpgsql functions. > This works OK. However, we want deletes to be recorded too, and there we want > the user who connected to be recorded in the log. So, how can I get the > co

Re: [GENERAL] Connected user in a triggerfunction

2006-01-19 Thread A. Kretschmer
am 20.01.2006, um 7:56:38 +0100 mailte Dick Kniep folgendes: > Hi list, > > We are using logging in a database based on triggers and plpgsql functions. > This works OK. However, we want deletes to be recorded too, and there we want > the user who connected to be recorded in the log. So, how ca

[GENERAL] Connected user in a triggerfunction

2006-01-19 Thread Dick Kniep
Hi list, We are using logging in a database based on triggers and plpgsql functions. This works OK. However, we want deletes to be recorded too, and there we want the user who connected to be recorded in the log. So, how can I get the connected user in a triggerfunction? Cheers, Dick Kniep --