Mercurial > libervia-pubsub

changeset 390:fba96e95e329

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
storage (pgsql): fixed filtering in getItemsPublishers
author Goffi <goffi@goffi.org>
date Fri, 15 Feb 2019 18:04:05 +0100
parents 66128656f76c
children 1d2222a91e6b
files src/pgsql_storage.py
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/src/pgsql_storage.py	Fri Feb 15 16:31:38 2019 +0100
+++ b/src/pgsql_storage.py	Fri Feb 15 18:04:05 2019 +0100
@@ -1264,8 +1264,8 @@
         ret = {}
         for itemIdentifier in itemIdentifiers:
             cursor.execute("""SELECT publisher FROM items
-                              WHERE item=%s""",
-                            (itemIdentifier,))
+                              WHERE node_id=%s AND item=%s""",
+                            (self.nodeDbId, itemIdentifier,))
             result = cursor.fetchone()
             if result:
                 ret[itemIdentifier] = jid.JID(result[0])