aboutsummaryrefslogtreecommitdiff
path: root/src/backenddb
diff options
context:
space:
mode:
Diffstat (limited to 'src/backenddb')
-rw-r--r--src/backenddb/pg_lookup_all_products.c6
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",