Re: Pg_catalog reference - Mailing list pgsql-general

From Vyacheslav Kalinin
Subject Re: Pg_catalog reference
Date
Msg-id 9b1af80e0712090958n14b794bet2c215ef46c946cfb@mail.gmail.com
Whole thread Raw
In response to Pg_catalog reference  (Anton Nikiforov <anton@nikiforov.ru>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jay
Date:
Subject: WHERE (columnX IN (x,y,z)) ORDER BY columnY conflict
Next
From: "Matthew Pulis"
Date:
Subject: Re: Improving the timing of a query