nms9403 opened a new issue, #2180: URL: https://github.com/apache/age/issues/2180
Hi. When Apache AGE (version 1.5.0) is included in shared_preload_libraries and its extension is created in a dedicated database (e.g., service_db, creating the ag_catalog schema there), attempting to run CREATE EXTENSION pg_stat_statements; in a different database (e.g., the default postgres database) fails with: ERROR: 3F000: schema "ag_catalog" does not exist; LOCATION: get_namespace_oid, namespace.c:3098. This occurs on PostgreSQL 15.12. The pg_stat_statements extension itself has no dependency on ag_catalog. The issue seems to stem from an attempted lookup of ag_catalog within the context of the postgres database, where it doesn't exist. Environment: PostgreSQL Version: 15.12 Apache AGE Version: 1.5.0 Suspected Cause: The globally preloaded AGE library components (due to shared_preload_libraries) appear to interfere with DDL commands in other databases. It's suspected that an AGE global hook or process attempts to reference ag_catalog without correctly checking the current database context, leading to the failure when CREATE EXTENSION pg_stat_statements is executed in a database lacking ag_catalog. Request: We request the Apache AGE development team to investigate this potential issue where AGE's presence in shared_preload_libraries might cause interference with standard extension DDL in other databases by incorrectly attempting to access its specific ag_catalog schema. -- 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.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org