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