These create table commands succeed, even tho the foreign key refers to a 'different' type (int2 product_id column refers to an int8 column):
CREATE TABLE products (
id int8 primary key,
name text not null
CREATE TABLE orders (
id int8 PRIMARY KEY,
product_id int2 not null REFERENCES products (id)
If I replace int2 with numeric, real, text, etc it fails as expected ("key columns are of incompatible types").
Expected: integer types should match exactly (or at least be large enough to hold the referenced value).
Never miss a thing. Make Yahoo your home page.
pgsql-general by date
|Next:||From: Stephan Szabo||Date: 2008-02-27 01:18:04|
|Subject: Re: bug in 8.3? foreign key refers to different type|
|Previous:||From: Joris Dobbelsteen||Date: 2008-02-26 23:51:34|
|Subject: Re: win32: how to backup (dump does not work)|