Skip site navigation (1) Skip section navigation (2)

Re: beta4 accepts foreign key of different type than column

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: beta4 accepts foreign key of different type than column
Date: 2008-01-06 15:18:35
Message-ID: 4780F14B.2050707@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers

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

In response to

Responses

pgsql-hackers by date

Next:From: Louis-David MitterrandDate: 2008-01-06 15:59:32
Subject: my bad (was: Re: beta4 accepts foreign key of different type thancolumn
Previous:From: Louis-David MitterrandDate: 2008-01-06 15:10:41
Subject: beta4 accepts foreign key of different type than column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group