Re: Trigger to run @ connection time?

Поиск
Список
Период
Сортировка
Искать
От
Marko Kreen
Тема
Re: Trigger to run @ connection time?
Дата
Msg-id
e51f66da0803140836s4d380363l5f432f3f1ce1977d@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Trigger to run @ connection time? "Kynn Jones" <kynnjo@gmail.com>
Re: Trigger to run @ connection time? Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: Trigger to run @ connection time? "Kynn Jones" <kynnjo@gmail.com>
Re: Trigger to run @ connection time? Tom Lane <tgl@sss.pgh.pa.us>
Re: Trigger to run @ connection time? "Daniel Verite" <daniel@manitou-mail.org>
Re: Trigger to run @ connection time? "Dawid Kuroczko" <qnex42@gmail.com>
Re: Trigger to run @ connection time? "Marko Kreen" <markokr@gmail.com>
Re: Trigger to run @ connection time? "Dawid Kuroczko" <qnex42@gmail.com>
Re: Trigger to run @ connection time? "Marko Kreen" <markokr@gmail.com>
Re: Trigger to run @ connection time? Erik Jones <erik@myemma.com>
Re: Trigger to run @ connection time? "Marko Kreen" <markokr@gmail.com>
Re: Trigger to run @ connection time? Robert Treat <xzilla@users.sourceforge.net>
Re: Trigger to run @ connection time? Erik Jones <erik@myemma.com>
Re: Trigger to run @ connection time? "Kynn Jones" <kynnjo@gmail.com>
Re: Trigger to run @ connection time? Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: Trigger to run @ connection time? btober@ct.metrocast.net
Re: Trigger to run @ connection time? Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: Trigger to run @ connection time? Berend Tober <btober@ct.metrocast.net>
Re: Trigger to run @ connection time? Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Re: Trigger to run @ connection time? "Andrej Ricnik-Bay" <andrej.groups@gmail.com>
Re: Trigger to run @ connection time? "Kynn Jones" <kynnjo@gmail.com>
Re: Trigger to run @ connection time? "Greg Sabino Mullane" <greg@turnstep.com>
On 3/14/08, Erik Jones  wrote:
>  On Mar 14, 2008, at 7:17 AM, Marko Kreen wrote:
>  > To put it to core Postgres, it needs to be conceptually sane
>  > first, without needing ugly workarounds to avoid it bringing
>  > whole db down.
>  >
>  > I can see ATM only few ways:
>  >
>  > - Applies only to non-superusers.
>  >
>  > - Error from CONNECT trigger does not affect superuser.
>  >
>  > - Applies to database + role.  Role could be also group of users.
>  >
>  > So you always have way do fix things, without hexediting in data
>  > dir...
>
> Another option:
>
>  Does not fire at all in single-user mode.  This would be covered by
>  "Applies to non-superusers" if that were there but, by itself, the
>  triggers would still fire for normal superuser connections.

Seems bit too hard - you may other db-s that work fine,
why should those suffer?

-- 
marko
В списке pgsql-general по дате отправления
От: Richard Huxton
Дата:
Сообщение: Re: LOCK TABLE HELP
От: Richard Huxton
Дата:
Сообщение: Re: LOCK TABLE HELP
FAQ