Re: Postgres CTE issues

> This is what I am trying:
>
> WITH x AS
>
> (INSERT INTO industry (name,abbr,description,cr_date,last_upd)
>
> VALUES ('df','','',now(),now()) returning id) insert into sector (name,description,cr_date,last_upd,industry_id) select 's1','',now(),now(),id from x;
>
> I get a error:
>
> ERROR: insert or update on table "sector" violates foreign key constraint "sector_id_fkey"
>
> DETAIL: Key (id)=(394) is not present in table "industry".
>
> If I execute the insert individually, I am able to insert a record. Wonder what I am doing wrong.

Hello,
Defining your FK as deferrable initially deferred should help here.
regards,

Marc Mamin