On Sun, Jan 06, 2008 at 10:18:35AM -0500, Andrew Dunstan wrote: > 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.
Sorry, false alarm. I just realised that I had previously also changed the person_type.person_type data type to the same enum. Cheers, ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
