referencing system catalogs

From: elein <elein(at)varlena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: elein <elein(at)varlena(dot)com>
Subject: referencing system catalogs
Date: 2004-06-27 00:31:11
Message-ID: 20040626173111.T30062@cookie.varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can someone explain the reasoning behind not allowing
a user table to contain a foreign key of a system table?

For example:

create table myusers (
login text references pg_catalog.pg_shadow(usename),
...
);

Fails with a message about using system catalogs.
Using pg_user fails because it is a view and not a table.

Is it because updates to the catalogs can be done outside
of transactions? Is that a good enough reason?

thanks,

elein
============================================================
elein(at)varlena(dot)com Varlena, LLC www.varlena.com

PostgreSQL Consulting, Support & Training

PostgreSQL General Bits http://www.varlena.com/GeneralBits/
=============================================================
I have always depended on the [QA] of strangers.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-06-27 01:13:06 Re: referencing system catalogs
Previous Message jay 2004-06-26 23:47:34 postgresql on debian