Multiple foreign keys issue about condenser HOT 3 CLOSED

Hi Dustin,

Are you writing your foreign keys from scratch in the FK Augmentation section? As I understand, calc.settings.market_id and calc.settings.market_uuid both point to public.market.id, where public.market.id is a bigint type. Do you do explicit type casts when normally querying between these columns? Since not all bigints can be proper UUID types in Postgres, we don't do an explicit cast here.

However, I would expect a dependency break (notably from calc.settings.market__uuid to public.market.id) to allow you to work around this. Would you mind sharing your configuration (connection details redacted?)

from condenser.

calc.settings.market_uuid does not point to public.market.id it points to public.market.uuid. So no we don't have to do any typecasting because they are different links.

It seems like the tool is assuming UUID is linked to ID though.

from condenser.

Hmmm, might be worth taking a look at your config and perhaps a schema dump of these two tables, something seems off.

from condenser.