| From: | craigp <craigp98072(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | bug in 8.3? foreign key refers to different type |
| Date: | 2008-02-27 00:27:26 |
| Message-ID: | 788837.69691.qm@web53910.mail.re2.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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).
thanks,
--craig
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2008-02-27 01:18:04 | Re: bug in 8.3? foreign key refers to different type |
| Previous Message | Joris Dobbelsteen | 2008-02-26 23:51:34 | Re: win32: how to backup (dump does not work) |