Re: [HACKERS] 9.1rc1 bug: extension types not dropped with DROP SCHEMA CASCADE

2011-09-10 Thread Marti Raudsepp
On Sat, Sep 10, 2011 at 15:44, Dimitri Fontaine wrote: > I believe this bug has already been fixed, but the fix is not in rc1. Thanks Thom and Dimitri, I'll make sure to test my bug reports with git master in the future. :) Regards, Marti -- Sent via pgsql-hackers mailing list (pgsql-hackers@p

Re: [HACKERS] 9.1rc1 bug: extension types not dropped with DROP SCHEMA CASCADE

2011-09-10 Thread Dimitri Fontaine
Marti Raudsepp writes: > Creating an extension in a schema and then dropping that schema > apparently doesn't clean up the extension's types: I believe this bug has already been fixed, but the fix is not in rc1. http://archives.postgresql.org/pgsql-bugs/2011-08/msg00120.php http://git.postg

Re: [HACKERS] 9.1rc1 bug: extension types not dropped with DROP SCHEMA CASCADE

2011-09-10 Thread Thom Brown
On 10 September 2011 12:46, Marti Raudsepp wrote: > Hi! > > Creating an extension in a schema and then dropping that schema > apparently doesn't clean up the extension's types: > db=# CREATE SCHEMA foo; > db=# CREATE EXTENSION cube WITH SCHEMA foo; > db=# DROP SCHEMA foo CASCADE; > NOTICE:  drop c

[HACKERS] 9.1rc1 bug: extension types not dropped with DROP SCHEMA CASCADE

2011-09-10 Thread Marti Raudsepp
Hi! Creating an extension in a schema and then dropping that schema apparently doesn't clean up the extension's types: db=# CREATE SCHEMA foo; db=# CREATE EXTENSION cube WITH SCHEMA foo; db=# DROP SCHEMA foo CASCADE; NOTICE: drop cascades to 6 other objects DETAIL: drop cascades to operator foo.