It is not possible to assign triggers to system tables hence it is impossible to reference system table in FK constraint. Obviously, users that don't exist in the database cannot modify anything, you can use "session_user" and "current_user" functions for logging purposes, see http://www.postgresql.org/docs/8.2/interactive/functions-info.html
- [GENERAL] Pg_catalog reference Anton Nikiforov
- Re: [GENERAL] Pg_catalog reference Richard Huxton
- Re: [GENERAL] Pg_catalog reference Vyacheslav Kalinin