referencing a sytem table

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

Browse pgsql-general by date

  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...