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 > to appearance, it is a function). > > > 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 get the connected user in a triggerfunction? > >> > >> Cheers, > >> Dick Kniep
