From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bradley Holbrook <operations_bradley@servillian.ca>
Cc: 'Viktor Bojović' <viktor.bojovic@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Drop Schema Error
Date: Mon, 31 Jan 2011 13:24:26 -0500
Message-ID: <19812.1296498266@sss.pgh.pa.us> (raw)
In-Reply-To: <00d201cbc170$af9c5ff0$0ed51fd0$@servillian.ca>
References: <00fe01cbbf46$a1c21c20$e5465460$@servillian.ca>
<12066.1296320275@sss.pgh.pa.us>
<AANLkTik8ze9GX+Zv8b7YBZDx4AY=dU9tkAnGu29JKum4@mail.gmail.com>
<00d201cbc170$af9c5ff0$0ed51fd0$@servillian.ca>
"Bradley Holbrook" <operations_bradley@servillian.ca> writes:
> I renamed the schema from permissions to _old_permissions and I believe this caused the error.
Uh, no, certainly not. pg_depend only cares about the objects' OIDs,
not their names. Testing in 8.3, it works fine:
regression=# create schema old_permissions;
CREATE SCHEMA
regression=# create function old_permissions.foo() returns int as
regression-# 'select 2+2' language sql;
CREATE FUNCTION
regression=# create function old_permissions.foo2(int) returns int as
'begin return $1 + 1; end' language plpgsql;
CREATE FUNCTION
regression=# alter schema old_permissions rename to "_old_permissions";
ALTER SCHEMA
regression=# DROP SCHEMA "_old_permissions" ;
NOTICE: function _old_permissions.foo2(integer) depends on schema _old_permissions
NOTICE: function _old_permissions.foo() depends on schema _old_permissions
ERROR: cannot drop schema _old_permissions because other objects depend on it
HINT: Use DROP ... CASCADE to drop the dependent objects too.
regression=# DROP SCHEMA "_old_permissions" CASCADE;
NOTICE: drop cascades to function _old_permissions.foo2(integer)
NOTICE: drop cascades to function _old_permissions.foo()
DROP SCHEMA
regression=#
As I said, we've never seen a reproducible example.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, operations_bradley@servillian.ca, viktor.bojovic@gmail.com
Subject: Re: Drop Schema Error
In-Reply-To: <19812.1296498266@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox