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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
