proposal : backend startup hook / after logon trigger - Mailing list pgsql-hackers

From Tomas Vondra
Subject proposal : backend startup hook / after logon trigger
Date
Msg-id 4EBC6852.5030605@fuzzy.cz
Whole thread Raw
Responses Re: proposal : backend startup hook / after logon trigger
Re: proposal : backend startup hook / after logon trigger
List pgsql-hackers
Hi,

I occasionally need to perform some action whenever a user connects, and
there's nothing like an "AFTER LOGON" trigger (available in some other
databases).

Is there any particular reason why there's not a "backend start hook",
executed right after a backend is initialized? I've tried a very simple
PoC (basically just a new hook definition, called from PostgresMain(),
see the after-logon-hook.diff (and a simple module that uses it is in
logon.c).

This obviously is not a complete patch or something, but is there a good
reason why this is a stupid idea?

Obviously this is a bit low-level approach, as most of the time the
triggers are implemented in a PL. But who says you can't call a PL from
the C module ...

Tomas

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: proposal: psql concise mode
Next
From: Andrew Dunstan
Date:
Subject: Re: Parsing output of EXPLAIN command in PostgreSQL