[SQL] foreign key on pg_shadow

2005-06-14 Thread M.D.G. Lange
Dear list, Upon designing our application we thought that the following setup would be a good idea to implement security: Using the pg_shadow table as it is: | pg_shadow | +-+ | usename | | usesysid| | usecreatedb | | usesuper| | usecatupd | | passwd | | valunt

Re: [SQL] foreign key on pg_shadow

2005-06-14 Thread Tom Lane
"M.D.G. Lange" <[EMAIL PROTECTED]> writes: > No matter what ON DELETE constraint I created, the system will not allow > me to create a foreign key, as pg_shadow is a system catalog. We do not support foreign keys (or indeed triggers of any kind) on system catalogs. I don't foresee that happening