Re: Connected user in a triggerfunction

Поиск
Список
Период
Сортировка
От Dick Kniep
Тема Re: Connected user in a triggerfunction
Дата
Msg-id 200601261606.57257.dick@kniep.nl
обсуждение исходный текст
Ответ на Re: Connected user in a triggerfunction  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: many row updates
Следующее
От: "John D. Burger"
Дата:
Сообщение: Re: pgstattuple output?