Re: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

M-Bostone commented on issue #1626:
URL: https://github.com/apache/age/issues/1626#issuecomment-2044714094

   Awesome, thanks for the update!
   
   On Tue, Apr 9, 2024 at 9:41 AM Julien Riou ***@***.***> wrote:
   
   > Closed #1626  as completed.
   >
   > —
   > Reply to this email directly, view it on GitHub
   > , or
   > unsubscribe
   > 

   > .
   > You are receiving this because you commented.Message ID:
   > ***@***.***>
   >
   


-- 
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: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

jriouovh closed issue #1626: Drop extension doesn't drop the ag_catalog schema
URL: https://github.com/apache/age/issues/1626


-- 
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: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

jriouovh commented on issue #1626:
URL: https://github.com/apache/age/issues/1626#issuecomment-2044254268

   Hello folks,
   
   Indeed, as the schema is defined in the control file, PostgreSQL will not 
remove the schema with the extension because it may hold data and not only 
schema objects. So, this is not a bug.
   
   We need to drop the schema manually when dropping the extension.
   
   Thank you all! I'm closing this issue.


-- 
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: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

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

   @jriouovh After looking into this, it does appear that schema for an 
extension is not dropped due to PostgreSQL. Please see the link above provided 
by @mingfang. As this appears to be out of the scope of an extension itself, 
you will need to drop the schema yourself, if desired. Hopefully, this is 
helpful.


-- 
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: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

mingfang commented on issue #1626:
URL: https://github.com/apache/age/issues/1626#issuecomment-2043005655

   I believe it is normal for Postgres to NOT drop any schemas when dropping 
extensions; Schemas are not part of an extension's dependency.


-- 
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: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

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

   @jriouovh I will try to look into why this is happening.


-- 
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: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

diangamichael commented on issue #1626:
URL: https://github.com/apache/age/issues/1626#issuecomment-2040760198

   Manually drop the "ag_catalog" schema using the drop schema ag_catalog; 
command after uninstalling the extension.
   This bug disrupts the expected behavior of the extension uninstallation 
process and requires extra steps for cleanup. It would be ideal to have the 
extension removal process also remove any associated schemas automatically to 
streamline the uninstallation process.


-- 
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: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

sir-sa commented on issue #1626:
URL: https://github.com/apache/age/issues/1626#issuecomment-2037013301

   If you are encountering the issue where the ag_catalog schema remains even 
after uninstalling the AGE extension (age), You can fix it by manually dropping 
thw ag_catalog schema. Below is how you can fix it:
   
   DROP SCHEMA IF EXISTS ag_catalog CASCADE;


-- 
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: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

M-Bostone commented on issue #1626:
URL: https://github.com/apache/age/issues/1626#issuecomment-2036781757

   basically your error comes up when PostgreSQL is trying to access a schema 
that does not exist in your current database.
   try double-checking the schema name in your query, or your schema is 
missing, and ensure that you've got the necessary permissions required to 
access the 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

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

Re: [I] Drop extension doesn't drop the ag_catalog schema [age]

[via GitHub]

mingfang commented on issue #1626:
URL: https://github.com/apache/age/issues/1626#issuecomment-2021247857

   I confirm that dropping the extension does not drop the ag_catalog schema.
   Whatever that is causing this problem is actually causing a much bigger 
problem for my entire Postgres instance.
   After the AGE was used once, it seems to leave a permanent dependency 
somewhere that's causing me to unable to delete any schemas.
   
   The steps to recreate the problem in psql
   ```sql
   create extension age;
   drop extension age;
   create database test;
   \c test
   drop schema public;
   ```
   The `drop schema public` statement will fail with
   ```
   ERROR:  schema "ag_catalog" does not exist
   ```
   


-- 
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