Meelis Mikko

Yeah, thanks a lot, this solved the issue :)

Thanks for the reply, I will try that out tomorrow But I think I tried that subselect also by replacing the :ID with a fixed imaginary number (such product_id might have not however have been in table), and then there was no error 'c.external_id in (select PROFILE_ID from saved_product_visibility where product_id=5)' Thats why i got feeling there is something wierd with the :ID being set there... But I guess if that select part inside () returns nothing then it might go trough?

Thanks for the reply, I will try that out tomorrow But I think I tried that command by replacing the :ID with a fixed imaginary number (such product_id might have not however have been in table), and then there was no error 'c.external_id in (select PROFILE_ID from saved_product_visibility where product_id=5)' Thats why i got feeling there is something wierd with the :ID being set there... But I guess if that select part inside () returns nothing then it might go trough?

I am basically trying to sync a table "saved_product" that fill certain criteria based on "saved_product_visibility" table from one node to another: saved_product_visibility id bigint NOT NULL, product_id bigint NOT NULL, profile_id bigint NOT NULL, ... saved_product id bigint NOT NULL, ... our external id for client equals proflile_id and we want to user that as one criteria i have simple subselect for saved_product table syncing ( that selects profileID from saved_product_visibility table ): router_expression...

I am basically trying to sync a table "saved_product" that fill certain criteria based on "saved_product_visibility" table from one node to another: saved_product_visibility id bigint NOT NULL, product_id bigint NOT NULL, profile_id bigint NOT NULL, ... saved_product id bigint NOT NULL, ... our external id for client equals proflileID and we want to user that as one criteria i have simple subselect for saved_product table syncing ( that selects profileID from saved_product_visibility table ): router_expression...