Re: [GENERAL] referencing system catalogs

2004-06-26 Thread Stephan Szabo
On Sat, 26 Jun 2004, elein wrote: > 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 textreferences pg_catalog.pg_shadow(usename), > ... > ); > > Fails with a messa

[GENERAL] referencing system catalogs

2004-06-26 Thread elein
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 textreferences pg_catalog.pg_shadow(usename), ... ); Fails with a message about using system catalogs. Using pg_user fail