[HACKERS] beta4 accepts foreign key of different type than column

2008-01-06 Thread Louis-David Mitterrand
Hi, I changed the data type on a column (to an enum) but the previous foreign key to the old table (replaced by the enum) is still accepted event though the data types are now different. Is that the expected behavior? CREATE TABLE person_to_event ( id_person integer NOT NULL,

Re: [HACKERS] beta4 accepts foreign key of different type than column

2008-01-06 Thread Andrew Dunstan
Louis-David Mitterrand wrote: Hi, I changed the data type on a column (to an enum) but the previous foreign key to the old table (replaced by the enum) is still accepted event though the data types are now different. Is that the expected behavior? CREATE TABLE person_to_event (

Re: [HACKERS] beta4 accepts foreign key of different type than column

2008-01-06 Thread Gregory Stark
Andrew Dunstan [EMAIL PROTECTED] writes: Louis-David Mitterrand wrote: Hi, I changed the data type on a column (to an enum) but the previous foreign key to the old table (replaced by the enum) is still accepted event though the data types are now different. Is that the expected behavior?

Re: [HACKERS] beta4 accepts foreign key of different type than column

2008-01-06 Thread Louis-David Mitterrand
On Sun, Jan 06, 2008 at 04:07:40PM +, Gregory Stark wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Louis-David Mitterrand wrote: Hi, I changed the data type on a column (to an enum) but the previous foreign key to the old table (replaced by the enum) is still accepted event