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) andLOADstatement.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 CASCADEand then create it againCREATE EXTENSION ageif possible (this will delete all data in your graph database).