Re: beta4 accepts foreign key of different type than column

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 (
> id_person integer NOT NULL,
> id_event integer NOT NULL,
> person_type person_type_new NOT NULL, -- new ENUM type
> "character" text
> )
>
> ALTER TABLE ONLY person_to_event
> ADD CONSTRAINT person_to_event_person_type_fkey FOREIGN KEY (person_type) REFERENCES person_type(person_type); -- old person_type table, text column
>
>
>

Please send us a more complete example. Also, using the same name for a
table, a field and a type makes reading it very confusing. Please make
sure your example uses names for just one purpose.

cheers

andrew