Re: Foreign key error, please help.

On Tue, 8 Mar 2005, Kumar S wrote:

> INSERT INTO
> processed_data(exp_id,seq_anno_id,cel_id,proc_symbol,proc_exprs,proc_pval)VALUES(
> (currval('experiment_exp_id_seq')),(SELECT
> platform_id from platform where platform_filename =
> 'RGeo-ESHSC-H1ES1-1a-U133A'),(SELECT seq_anno_id FROM
> sequence_annotation, genechip WHERE
> sequence_annotation.seq_probeset_id =
> 'AFFX-r2-Ec-bioB-M_at'AND
> sequence_annotation.genechip_id = genechip.genechip_id
> AND genechip.genechip_array =
> 'U133A'),'AFFX-r2-Ec-bioB-M_at',6.419,0.1671675);

It looks to me like the select platform_id subselect is in the column
position for seq_anno_id not the select seq_anno_id subselect which
doesn't seem to be what's intended.