From: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
---|---|
To: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | Foreign key constraint accepted even when not same data type |
Date: | 2003-09-22 08:18:28 |
Message-ID: | 3F6EB054.3080302@mega-bucks.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Is it right for postgres to accept a foreign key constraint when the
type of the field is not the same as that of the foreign key?
For example:
# Create table a (id int primary key);
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'a_pkey'
for table 'a'
CREATE TABLE
# Create table b (id2 text references a(id));
NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
CREATE TABLE
# \d a
Table "public.a"
Column | Type | Modifiers
--------+---------+-----------
id | integer | not null
Indexes: a_pkey primary key btree (id)
# \d b
Table "public.b"
Column | Type | Modifiers
--------+------+-----------
id2 | text |
Foreign Key constraints: $1 FOREIGN KEY (id2) REFERENCES a(id) ON UPDATE
NO ACTION ON DELETE NO ACTION
Jean-Christian Imbeault
From | Date | Subject | |
---|---|---|---|
Next Message | shreedhar | 2003-09-22 10:44:20 | Warning: PostgreSQL query failed |
Previous Message | Oscar I. del Rey | 2003-09-22 07:36:42 | cannot insert or update |