diangamichael commented on issue #1767: URL: https://github.com/apache/age/issues/1767#issuecomment-2077548019
It seems like you're encountering an error when trying to execute a SQL command that creates a table using the results of a Cypher query in PostgreSQL. The error message indicates that there's an unhandled Cypher function call. Based on the provided information, it looks like the issue might be related to how PostgreSQL handles the Cypher function call within the CREATE TABLE AS SELECT statement. One workaround you've found is to first create an empty table and then insert the results of the Cypher query into that table, which seems to work fine. To address this, you may need to modify the parser or add a hook to handle Cypher function calls within the context of CREATE TABLE AS SELECT statements. This could involve updating the PostgreSQL extension you're using to handle Cypher queries or making adjustments to the PostgreSQL configuration to support this functionality. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
