> create table fp1(a text, b text, primary key(a,b));
> create table foo (a text, b numeric, c text);
>
> insert into foo select 'a', 1, explode_array(string_to_array('a,b',
> ',')); -- works
> truncate foo;
> alter table foo add foreign key(a,b) references fp1(a,b) on delete cascade;
>
> insert into foo select 'a', 1, explode_array(string_to_array('a,b',
> ',')); -- fails
does it matter that fp1.b is text but foo.b is numeric?
Regards,
Richar Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
