You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Either try to find a way to specify a context in the function generation, or instantiate separate connections foreach schema, or explicitly preface the non-primary schema functions with their schema.
[psql] SELECT*FROMusda.get_nutrients_by_food_ids(ARRAY[1002]);
[psql] ERROR: relation "food_des" does not exist
LINE9: food_des des
^
QUERY:
SELECTdes.id,
des.fdgrp_id,
long_desc,
manufacturer,
json_agg(json_build_object('nutr_id', val.nutr_id, 'nutr_desc', nutr_desc, 'tagname', tagname, 'nutr_val', nutr_val, 'units', units)) AS nutrients
FROM
food_des des
LEFT JOIN nut_data val ONval.food_id=des.idLEFT JOIN nutr_def def ONdef.id=val.nutr_idWHEREdes.id= ANY (food_id_in)
GROUP BYdes.id,
long_desc
CONTEXT: SQL function "get_nutrients_by_food_ids" during startup
The text was updated successfully, but these errors were encountered:
Either try to find a way to specify a context in the function generation, or instantiate separate connections foreach schema, or explicitly preface the non-primary schema functions with their schema.
The text was updated successfully, but these errors were encountered: