| 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: | Whole Thread | Raw Message | 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.
| 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 |