From: | clemens schmuck <clemens(dot)schmuck(at)ins(dot)at> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | referencing a sytem table |
Date: | 2001-01-18 06:44:38 |
Message-ID: | 5.0.0.25.2.20010118073713.00a6dd08@mailhost.ins.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-18 07:14:07 | Re: Using max() MUCH slower in v7.1 |
Previous Message | Anand Raman | 2001-01-18 06:05:08 | Re: stupid select question... |