We are trying to left join a table ( 536 records ) to another ( 780 records ).
However, getting this error message:
“This query cannot be planned possibly due to either a cartesian join or an inequality join”
The flag “planner.enable_nljoin_for_scalar_only” is set.
Anything regards setting we’re missing, how else to join a table without having an error .