diff options
| -rw-r--r-- | src/backenddb/pg_lookup_all_products.c | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/backenddb/pg_lookup_all_products.c b/src/backenddb/pg_lookup_all_products.c index 31320d59..a80a19ee 100644 --- a/src/backenddb/pg_lookup_all_products.c +++ b/src/backenddb/pg_lookup_all_products.c @@ -169,8 +169,8 @@ TMH_PG_lookup_all_products (void *cls, ",minimum_age" ",product_id" ",product_serial" - " FROM merchant_inventory" - " JOIN merchant_instances" + " FROM merchant_inventory mi" + " JOIN merchant_instances inst" " USING (merchant_serial)" ",LATERAL (" " SELECT ARRAY (" @@ -179,7 +179,7 @@ TMH_PG_lookup_all_products (void *cls, " WHERE mpc.product_serial = mi.product_serial" " ) AS category_array" " ) t" - " WHERE merchant_instances.merchant_id=$1"); + " WHERE inst.merchant_id=$1"); qs = GNUNET_PQ_eval_prepared_multi_select ( pg->conn, "lookup_all_products", |