| 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: | Whole Thread | Raw Message | 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... |