Re: Trigger to run @ connection time?
От
Marko Kreen
Тема
Re: Trigger to run @ connection time?
Дата
Msg-id
e51f66da0803140836s4d380363l5f432f3f1ce1977d@mail.gmail.com
Ответ на
Re: Trigger to run @ connection time? (Erik Jones)
Список
Дерево обсуждения
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 по дате отправления