referencing a sytem table - Mailing list pgsql-general

From clemens schmuck
Subject referencing a sytem table
Date
Msg-id 5.0.0.25.2.20010118073713.00a6dd08@mailhost.ins.at
Whole thread Raw
List pgsql-general
hi,

environment: PostgreSQL 7.0.3,i686-pc-linux-gnu

to save more data of my database users i wanted to make a user_profile
table wihich is referenced to pg shadow 1:1. trying this i encountered the
problem that postgres does not semm to force referential integrity  when
referencing a system table. is that right - or am i wrong? how can i do a
thing like this?

here are the sql statements i used:


Create Table profile_test (
    p_usename name)

Alter table profile_test add constraint fk_1  FOREIGN KEY (p_usename)
REFERENCES
pg_shadow(usename) MATCH FULL;

insert into profile_test (p_usename) VALUES ('nosuchuser')  ----> SUCCESS!!!!




thanks in advance
clemens


pgsql-general by date:

Previous
From: Anand Raman
Date:
Subject: Re: stupid select question...
Next
From: "Dan Langille"
Date:
Subject: GET DIAGNOSTICS SELECT PROCESSED INTO