referencing system catalogs
От | elein |
---|---|
Тема | referencing system catalogs |
Дата | |
Msg-id | 20040626173111.T30062@cookie.varlena.com обсуждение исходный текст |
Ответы |
Re: referencing system catalogs
|
Список | 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@varlena.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 по дате отправления: