Re: [I] Need postgres with graph extensions running on windows OS [age]

2024-02-09 Thread via GitHub


jrgemignani commented on issue #1542:
URL: https://github.com/apache/age/issues/1542#issuecomment-1936771323

   @MironAtHome Unfortunately, I haven't done Windows coding in a long while 
and can't help. I will see if any others on the team might be able to assist 
you.


-- 
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-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



[VOTE] Apache AGE 1.5.0 Release for PostgreSQL 14

2024-02-09 Thread John Gemignani
Dear Apache Community,

Please carefully read all instructions as they may have changed since the
last vote thread.

This is an official vote for Apache AGE release 1.5.0 for PostgreSQL 14.

To learn more about Apache AGE, please see http://age.apache.org/

Functionalities included and addressed in this release are:

*
Release Notes for Apache AGE release 1.5.0 for PostgreSQL version 14

Apache AGE 1.5.0 - Release Notes

NOTE: Due to the complexity and the amount of additions, there are no
   upgrade scripts to this release.

NOTE: Some of these reference the master branch PR that was
either applied to lower versions via a separate PR or
merged into a newly created branch.

Add additional index support and performance enhancements (#1232)
Add an additional way to find a previous variable ref (#1450)
Add auto apply labeler workflow for PRs (#1161)
Add checks for array functions to recognize and decode VPC (#1064)
Add concat || operator to agtype (#1198)
Add exist(?, ?|, ?&) operators for agtype (#1218)
Add missing dependency in cypher_expr.c (#1256)
Add path extraction(#>, #>>)operators to agtype (#1224)
Add support for chained expressions in CASE (#1431)
Clean up agtype_to_int8, agtype_to_int4, & agtype_to_int2 (#1354)
Clean up #included files in parser directory (#1465)
Converted SQL main file into multiple files. (#1401)
docs: Add to Docker setup (#1204)
Extend access(->, ->>), addition and subtraction operators (#1258)
Extend agtype containment operators (@>, <@) (#1285)
Extend EXPLAIN and add config param to switch transformation of property
filter (#1262)
Fix ambiguous conditions (#1373)
Fix DockerHub warning messages for latest (#1380)
Fix issue #1045 - error using path var in WHERE (#1295)
Fix Issue #1159 - Server terminates for SET plus-equal (#1160)
Fix issue #1219 - MERGE not seeing previous clause var (#1441)
Fix issue #1302 - crash on NULL input to UNWIND (#1304)
Fix issue #1303 - Server crashes on executing SELECT * FROM agtype(null);
(#1317)
Fix Issue #1305 - drop_label NULL cases (#1306)
Fix Issue #1329 - agtype_to_int4 crash (#1339)
Fix issue #1347 - unknow type of agtype container 0 (#1349)
Fix issue #1389 - Server crash on using null operand for access operators
(#1390)
Fix issue #1393 - previous clause variables not seen with EXISTS (#1426)
Fix issue #1398 - SET followed by DELETE does not delete (#1412)
Fix issue #1399 - EXISTS doesn't handle non-existent labels (#1400)
Fix Issue #945 - incorrect count(*) return values (#1288)
Fix typo in agtype_raw.h header guard (#1368)
Implement chained expression order of operations (#1402)
Implemented age_tail function (#1283)
Implemented the toBooleanList() function (#1014)
Implement EXISTS subquery for CASE (#1345)
Master to PostgreSQL version 16 (#1451)
Minor fix in agtype_volatile_wrapper function (#1172)
Modify COUNT() to output agtype (#1311)
Optimize performance of detach delete (#1271)
Optimize vertex and edge builder functions (#1252)
py_driver : optimised Antlr4ResultHandler to improve time (#1107)
Refactor Regression Tests for CASE statement (#1268)
Refactor the IN operator to use '= ANY()' syntax (#1236)
Removed unnecessary assignment (#1185)
Remove redundant job from CIs (#1473)
Remove unnecessary #include in src/backend/utils
Updated age.control.
Updated files, format, and version information.
Updated Makefile.
Updated RELEASE.
Update Discord channel in README.md (#1253)
Update README.md file for PostgreSQL version 16 support (#1463)
Update the Python Driver (#1246)

*
!!! PLEASE VERIFY ALL of the below tags, hash, links, signatures, and keys
!!!

The git tag to be discussed and voted on:
https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0

The git commit hash:
commit ffc3072127f4a6da72eb4b99c4aca6dce28fd145

The release files for 1.5.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG14/1.5.0.rc0/

Signatures used for AGE RCs can be found in this file:
https://downloads.apache.org/age/KEYS

The fingerprint of key to sign release artifacts:
4293 0603 8E35 AC05 4DBB  4B58 26B6 CD9D CD5B 0045

For information about the contents of this release see:
https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0

*

!!! IMPORTANT PLEASE READ !!!

Please note that Apache REQUIRES the following information to be in your
response to the vote, in order for it to be valid -

- If you are a binding vote, a PMC, then you MUST state it in your
  response. Otherwise, leave it out. Do not mention it if you are
  not a PMC.

- You MUST state what you checked to support your vote. See
  the samples given below for guidance.

- You MUST, at a minimum, check the above tags, hash,
   links, and signatures for validity.

- You CANNOT just say, +1 or 0. You need to state what items
 

Re: [I] Need postgres with graph extensions running on windows OS [age]

2024-02-09 Thread via GitHub


MironAtHome commented on issue #1542:
URL: https://github.com/apache/age/issues/1542#issuecomment-1936698922

   When running regression I am seeing this error: cache lookup failed for type 
190232
   It would seem related to my missing some component in the extension creation 
SQL script.
   Debugger session seems to help with some of the troubleshooting, but it 
would take from me a bit more to ram up.
   Any suggestion is greatly appreciated.
   Error is related to the very first regression script statement:
   SELECT * FROM ag_catalog.create_graph('ag_graph_1');


-- 
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-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



Re: [DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 14

2024-02-09 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official [VOTE] thread for Apache AGE 1.5.0 for PostgreSQL 14
shortly.

Thank you all for your input,

John Gemignani

On Fri, Feb 9, 2024 at 11:42 AM Eya Badal  wrote:

> Checked the following:
> - Release Notes
> - Git Tag
> - Commit Hash
> - Links and signature
>
> Thank you!!
>
> On 2024/02/06 23:19:44 John Gemignani wrote:
> > Dear Apache Community,
> >
> > We would like to open a discussion for the Apache AGE release 1.5.0 for
> > PostgreSQL 14.
> >
> > To learn more about Apache AGE, please see http://age.apache.org/
> >
> > Functionalities included and addressed in this release are:
> >
> > *
> > Release Notes for Apache AGE release 1.5.0 for PostgreSQL version 14
> >
> > Apache AGE 1.5.0 - Release Notes
> >
> > NOTE: Due to the complexity and the amount of additions, there are no
> > upgrade scripts to this release.
> >
> > NOTE: Some of these reference the master branch PR that was
> > either applied to lower versions via a separate PR or
> > merged into a newly created branch.
> >
> > Add additional index support and performance enhancements (#1232)
> > Add an additional way to find a previous variable ref (#1450)
> > Add auto apply labeler workflow for PRs (#1161)
> > Add checks for array functions to recognize and decode VPC (#1064)
> > Add concat || operator to agtype (#1198)
> > Add exist(?, ?|, ?&) operators for agtype (#1218)
> > Add missing dependency in cypher_expr.c (#1256)
> > Add path extraction(#>, #>>)operators to agtype (#1224)
> > Add support for chained expressions in CASE (#1431)
> > Clean up agtype_to_int8, agtype_to_int4, & agtype_to_int2 (#1354)
> > Clean up #included files in parser directory (#1465)
> > Converted SQL main file into multiple files. (#1401)
> > docs: Add to Docker setup (#1204)
> > Extend access(->, ->>), addition and subtraction operators (#1258)
> > Extend agtype containment operators (@>, <@) (#1285)
> > Extend EXPLAIN and add config param to switch transformation of property
> > filter (#1262)
> > Fix ambiguous conditions (#1373)
> > Fix DockerHub warning messages for latest (#1380)
> > Fix issue #1045 - error using path var in WHERE (#1295)
> > Fix Issue #1159 - Server terminates for SET plus-equal (#1160)
> > Fix issue #1219 - MERGE not seeing previous clause var (#1441)
> > Fix issue #1302 - crash on NULL input to UNWIND (#1304)
> > Fix issue #1303 - Server crashes on executing SELECT * FROM agtype(null);
> > (#1317)
> > Fix Issue #1305 - drop_label NULL cases (#1306)
> > Fix Issue #1329 - agtype_to_int4 crash (#1339)
> > Fix issue #1347 - unknow type of agtype container 0 (#1349)
> > Fix issue #1389 - Server crash on using null operand for access operators
> > (#1390)
> > Fix issue #1393 - previous clause variables not seen with EXISTS (#1426)
> > Fix issue #1398 - SET followed by DELETE does not delete (#1412)
> > Fix issue #1399 - EXISTS doesn't handle non-existent labels (#1400)
> > Fix Issue #945 - incorrect count(*) return values (#1288)
> > Fix typo in agtype_raw.h header guard (#1368)
> > Implement chained expression order of operations (#1402)
> > Implemented age_tail function (#1283)
> > Implemented the toBooleanList() function (#1014)
> > Implement EXISTS subquery for CASE (#1345)
> > Master to PostgreSQL version 16 (#1451)
> > Minor fix in agtype_volatile_wrapper function (#1172)
> > Modify COUNT() to output agtype (#1311)
> > Optimize performance of detach delete (#1271)
> > Optimize vertex and edge builder functions (#1252)
> > py_driver : optimised Antlr4ResultHandler to improve time (#1107)
> > Refactor Regression Tests for CASE statement (#1268)
> > Refactor the IN operator to use '= ANY()' syntax (#1236)
> > Removed unnecessary assignment (#1185)
> > Remove redundant job from CIs (#1473)
> > Remove unnecessary #include in src/backend/utils
> > Updated age.control.
> > Updated files, format, and version information.
> > Updated Makefile.
> > Updated RELEASE.
> > Update Discord channel in README.md (#1253)
> > Update README.md file for PostgreSQL version 16 support (#1463)
> > Update the Python Driver (#1246)
> >
> > *
> >
> > The git tag to be discussed and voted on:
> > https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0
> >
> > The git commit hash:
> > commit ffc3072127f4a6da72eb4b99c4aca6dce28fd145
> >
> > The release files for 1.5.0, can be found at:
> > https://dist.apache.org/repos/dist/dev/age/PG14/1.5.0.rc0/
> >
> > Signatures used for AGE RCs can be found in this file:
> > https://downloads.apache.org/age/KEYS
> >
> > The fingerprint of key to sign release artifacts:
> > 4293 0603 8E35 AC05 4DBB  4B58 26B6 CD9D CD5B 0045
> >
> > For information about the contents of this release see:
> > https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0
> >
> > Please 

Re: [I] Need postgres with graph extensions running on windows OS [age]

2024-02-09 Thread via GitHub


MironAtHome commented on issue #1542:
URL: https://github.com/apache/age/issues/1542#issuecomment-1936506572

   Similar for Postgres 16
   https://github.com/MironAtHome/agewin/tree/port/win32msvc/PG16/1.5.0
   Any help testing  ( within scope of port and some function substitution ) 
greatly appreciated.


-- 
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-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



Re: [DISCUSS] Apache AGE 1.5.0 Release for PostgreSQL 14

2024-02-09 Thread Eya Badal
Checked the following:
- Release Notes
- Git Tag
- Commit Hash
- Links and signature

Thank you!! 

On 2024/02/06 23:19:44 John Gemignani wrote:
> Dear Apache Community,
> 
> We would like to open a discussion for the Apache AGE release 1.5.0 for
> PostgreSQL 14.
> 
> To learn more about Apache AGE, please see http://age.apache.org/
> 
> Functionalities included and addressed in this release are:
> 
> *
> Release Notes for Apache AGE release 1.5.0 for PostgreSQL version 14
> 
> Apache AGE 1.5.0 - Release Notes
> 
> NOTE: Due to the complexity and the amount of additions, there are no
> upgrade scripts to this release.
> 
> NOTE: Some of these reference the master branch PR that was
> either applied to lower versions via a separate PR or
> merged into a newly created branch.
> 
> Add additional index support and performance enhancements (#1232)
> Add an additional way to find a previous variable ref (#1450)
> Add auto apply labeler workflow for PRs (#1161)
> Add checks for array functions to recognize and decode VPC (#1064)
> Add concat || operator to agtype (#1198)
> Add exist(?, ?|, ?&) operators for agtype (#1218)
> Add missing dependency in cypher_expr.c (#1256)
> Add path extraction(#>, #>>)operators to agtype (#1224)
> Add support for chained expressions in CASE (#1431)
> Clean up agtype_to_int8, agtype_to_int4, & agtype_to_int2 (#1354)
> Clean up #included files in parser directory (#1465)
> Converted SQL main file into multiple files. (#1401)
> docs: Add to Docker setup (#1204)
> Extend access(->, ->>), addition and subtraction operators (#1258)
> Extend agtype containment operators (@>, <@) (#1285)
> Extend EXPLAIN and add config param to switch transformation of property
> filter (#1262)
> Fix ambiguous conditions (#1373)
> Fix DockerHub warning messages for latest (#1380)
> Fix issue #1045 - error using path var in WHERE (#1295)
> Fix Issue #1159 - Server terminates for SET plus-equal (#1160)
> Fix issue #1219 - MERGE not seeing previous clause var (#1441)
> Fix issue #1302 - crash on NULL input to UNWIND (#1304)
> Fix issue #1303 - Server crashes on executing SELECT * FROM agtype(null);
> (#1317)
> Fix Issue #1305 - drop_label NULL cases (#1306)
> Fix Issue #1329 - agtype_to_int4 crash (#1339)
> Fix issue #1347 - unknow type of agtype container 0 (#1349)
> Fix issue #1389 - Server crash on using null operand for access operators
> (#1390)
> Fix issue #1393 - previous clause variables not seen with EXISTS (#1426)
> Fix issue #1398 - SET followed by DELETE does not delete (#1412)
> Fix issue #1399 - EXISTS doesn't handle non-existent labels (#1400)
> Fix Issue #945 - incorrect count(*) return values (#1288)
> Fix typo in agtype_raw.h header guard (#1368)
> Implement chained expression order of operations (#1402)
> Implemented age_tail function (#1283)
> Implemented the toBooleanList() function (#1014)
> Implement EXISTS subquery for CASE (#1345)
> Master to PostgreSQL version 16 (#1451)
> Minor fix in agtype_volatile_wrapper function (#1172)
> Modify COUNT() to output agtype (#1311)
> Optimize performance of detach delete (#1271)
> Optimize vertex and edge builder functions (#1252)
> py_driver : optimised Antlr4ResultHandler to improve time (#1107)
> Refactor Regression Tests for CASE statement (#1268)
> Refactor the IN operator to use '= ANY()' syntax (#1236)
> Removed unnecessary assignment (#1185)
> Remove redundant job from CIs (#1473)
> Remove unnecessary #include in src/backend/utils
> Updated age.control.
> Updated files, format, and version information.
> Updated Makefile.
> Updated RELEASE.
> Update Discord channel in README.md (#1253)
> Update README.md file for PostgreSQL version 16 support (#1463)
> Update the Python Driver (#1246)
> 
> *
> 
> The git tag to be discussed and voted on:
> https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0
> 
> The git commit hash:
> commit ffc3072127f4a6da72eb4b99c4aca6dce28fd145
> 
> The release files for 1.5.0, can be found at:
> https://dist.apache.org/repos/dist/dev/age/PG14/1.5.0.rc0/
> 
> Signatures used for AGE RCs can be found in this file:
> https://downloads.apache.org/age/KEYS
> 
> The fingerprint of key to sign release artifacts:
> 4293 0603 8E35 AC05 4DBB  4B58 26B6 CD9D CD5B 0045
> 
> For information about the contents of this release see:
> https://github.com/apache/age/releases/tag/PG14/v1.5.0-rc0
> 
> Please verify the above links, files, and signatures in addition to sharing
> your thoughts and feedback and if we can call for a vote.
> 
> Thank you for your time.
> 
> John Gemignani
> 


Re: [I] The Go driver becomes "undefined: parser", and the application cannot be built. [age]

2024-02-09 Thread via GitHub


jrgemignani commented on issue #1455:
URL: https://github.com/apache/age/issues/1455#issuecomment-1936318910

   @maehara-n Could you verify this by pulling down the PR and testing it? I 
would rather not merge a PR that doesn't resolve an issue. Might, isn't 
compelling enough especially since everything on my side works without this PR.


-- 
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-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org