Postgres CTE issues

Hello,

I am new to postgres. I have a scenario where I need a trigger that inserts
values into n tables but dome of those tables are related.

I dug up some documents and I stumbled across CTE or teh with statement.

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.

I have been stuck with this issue for over 24 hours. Appreciate any help.

- Shekar