age: Query resulting in error: cannot cast agtype integer to type boolean
Hello again (this might happen a lot).
I’m getting the following error when trying to run the below query: cannot cast agtype integer to type boolean
(in NodeJS, using pg library):
SELECT * FROM ag_catalog.cypher('minmail', $$
MATCH (u:User {_id: $userId})-[:has]->(p:Profile)
WHERE p.deleted IS NULL
RETURN p
$$, $1) as (p ag_catalog.agtype);
Params:
'{"userId":"e4510317-67dc-4002-b28d-347699c8f8ca"}'
Any clue as to what I might be doing wrong?
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 15 (8 by maintainers)
Additionally, in current docker image automatically execute
CREATE EXTENSION
(default database) andLOAD
statement.There is no upgrade script to upgrade to latest. In order to use the latest version, I think you will have to drop the extension age
DROP EXTENSION age CASCADE
and then create it againCREATE EXTENSION age
if possible (this will delete all data in your graph database).