[GitHub] [incubator-age] lnoir commented on issue #210: Dynamic queries

lnoir commented on issue #210: URL: https://github.com/apache/incubator-age/issues/210#issuecomment-1109420302 Hi @JoshInnis, thanks for your quick response and help. I figured out the problem and realised the correct approach. :+1: It wasn't clear to me how I should construct and ex

[GitHub] [incubator-age] lnoir closed issue #210: Dynamic queries

lnoir closed issue #210: Dynamic queries URL: https://github.com/apache/incubator-age/issues/210 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-uns

[GitHub] [incubator-age] lnoir opened a new issue, #211: Query resulting in error: cannot cast agtype integer to type boolean

lnoir opened a new issue, #211: URL: https://github.com/apache/incubator-age/issues/211 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): ```

[GitHub] [incubator-age] pdpotter commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

pdpotter commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109457879 Is it possible to post the CREATE queries for `u:User` and `p:Profile`? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to

[GitHub] [incubator-age] emotionbug commented on issue #204: Dockerfile builds head of master, making Docker Hub builds incongruent with version tag

emotionbug commented on issue #204: URL: https://github.com/apache/incubator-age/issues/204#issuecomment-1109470444 just now, manually pushed v1.0.0, v0.6.0. Now, just need to modify the README. -- This is an automated message from the Apache Git Service. To respond to the message, plea

[GitHub] [incubator-age] lnoir commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

lnoir commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109504583 Hi @pdpotter, they were created via `load_labels_from_file`. Create statement: ``` SET search_path = ag_catalog, "$user", public; SELECT create_vlabel('minmail','User

[GitHub] [incubator-age] pdpotter commented on issue #45: unique properties / indexing

pdpotter commented on issue #45: URL: https://github.com/apache/incubator-age/issues/45#issuecomment-1109525588 Wow, this is fantastic. It is now possible to create relations quickly (~10 000/s on my local VM) using simple queries (with executemany) in the form of ``` SELECT * FROM cyp

[GitHub] [incubator-age] pdpotter commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

pdpotter commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109553300 I tried creating a minimal example using for user: ``` SELECT * FROM cypher('minmail', $$ CREATE (u:User {_id: "e4510317-67dc-4002-b28d-347699c8f8ca"}) RETURN u $$)

[GitHub] [incubator-age] lnoir commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

lnoir commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109560651 Thanks @pdpotter. Headers are below. User.csv: ``` "id","_id" ``` Profile.csv ``` "id","_id","email","access","label","primary","updated","notes","name"

[GitHub] [incubator-age] pdpotter commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

pdpotter commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109576881 I tried loading the User and Profile from CSV files (except for the :has relation, as I don't have the header and data for that file), but I still don't get an error message. Ca

[GitHub] [incubator-age] lnoir commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

lnoir commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109607601 I tried reducing the User.csv to a single user, the Profile.csv to a single Profile, and the has.csv to just that relationship, but still encountering the same issue when running t

[GitHub] [incubator-age] pdpotter commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

pdpotter commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109616147 I imported the `has` relation from csv as well now, and don't encounter errors when executing ``` SELECT * FROM ag_catalog.cypher('minmail', $$ MATCH (u:User {_id:

[GitHub] [incubator-age] lnoir commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

lnoir commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109637705 > Have you tried executing the MATCH query (above) hard coded, so without the parameter? Yes, I was originally running the queries raw, hardcoded directly in pgAdmin4. I ran

[GitHub] [incubator-age] pdpotter commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

pdpotter commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109653483 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

[GitHub] [incubator-age] lnoir commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

lnoir commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109650508 I tried v1.0.0, the result was the same. However, latest I get the following error: ``` operator does not exist: ag_catalog.agtype @> ag_catalog.agtype ``` I don't k

[GitHub] [incubator-age] lnoir commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

lnoir commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1109658224 Okay, thanks. I followed your instructions and now it's producing the original error. So, no change. -- This is an automated message from the Apache Git Service. To respond to th

[GitHub] [incubator-age] JoshInnis closed issue #209: I think the date is wrong

JoshInnis closed issue #209: I think the date is wrong URL: https://github.com/apache/incubator-age/issues/209 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e

[GitHub] [incubator-age] JoshInnis commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

JoshInnis commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1110359377 Hi @lnoir, You said you were using Postgres' NodeJS driver, correct? Not the one located here: https://github.com/apache/incubator-age/tree/master/drivers/nodejs

[GitHub] [incubator-age] emotionbug commented on issue #211: Query resulting in error: cannot cast agtype integer to type boolean

emotionbug commented on issue #211: URL: https://github.com/apache/incubator-age/issues/211#issuecomment-1110543204 If `search_path` is not specified, the above error may be reproduced. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to