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

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.

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

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.

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

jriouovh opened a new issue, #1626: URL: https://github.com/apache/age/issues/1626 **Describe the bug** When the extension is uninstalled, the `ag_catalog` schema remains. **How are you accessing AGE (Command line, driver, etc.)?** Command line. **What data setup