Can someone explain the reasoning behind not allowing
a user table to contain a foreign key of a system table?
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?
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.
pgsql-general by date
|Next:||From: Stephan Szabo||Date: 2004-06-27 01:13:06|
|Subject: Re: referencing system catalogs|
|Previous:||From: jay||Date: 2004-06-26 23:47:34|
|Subject: postgresql on debian |