Re: Pg_catalog reference

From: "Vyacheslav Kalinin" <vka(at)mgcp(dot)com>
To: "Anton Nikiforov" <anton(at)nikiforov(dot)ru>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pg_catalog reference
Date: 2007-12-09 17:58:08
Message-ID: 9b1af80e0712090958n14b794bet2c215ef46c946cfb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-12-09 18:08:23 Re: insert into...
Previous Message Dave Cramer 2007-12-09 17:02:03 Re: insert into...