diff options
| author | Christophe Romain <christophe.romain@process-one.net> | 2016-07-05 16:16:40 +0200 |
|---|---|---|
| committer | Christophe Romain <christophe.romain@process-one.net> | 2016-07-05 16:16:40 +0200 |
| commit | 3820aaa4216e3254fdeb0cfe545f40a35150752d (patch) | |
| tree | 500dd8f9b999c57cde9765c2c732b4da14924293 /src/nodetree_tree_sql.erl | |
| parent | Fix use of like parameter in sql pubsub's requests (diff) | |
Quote reserver 'type' keyword for pgsql to fix e300f80
Diffstat (limited to 'src/nodetree_tree_sql.erl')
| -rw-r--r-- | src/nodetree_tree_sql.erl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/nodetree_tree_sql.erl b/src/nodetree_tree_sql.erl index fb5141bf3..edfdbc1d5 100644 --- a/src/nodetree_tree_sql.erl +++ b/src/nodetree_tree_sql.erl @@ -202,7 +202,7 @@ get_subnodes_tree(Host, Node) -> ?SQL("select @(node)s, @(parent)s, @(type)s, @(nodeid)d from " "pubsub_node where host=%(H)s" " and node like %(N)s escape '^'" - " and type='hometree'")) + " and \"type\"='hometree'")) of {selected, RItems} -> [raw_to_node(Host, Item) || Item <- RItems]; @@ -264,7 +264,7 @@ delete_node(Host, Node) -> catch ejabberd_sql:sql_query_t( ?SQL("delete from pubsub_node where host=%(H)s" " and (node=%(Node)s" - " or (type = 'hometree' and node like %(N)s escape '^'))")), + " or (\"type\"='hometree' and node like %(N)s escape '^'))")), Removed. %% helpers |