Обсуждение: Change stored procedures schema name
There exist any way to change the name of my stored procedures schemas but the code used inside of them???
for example:
I have this stored procedure:
CREATE OR REPLACE FUNCTION schema1.example(double precision) RETURNS numeric AS
$BODY$
DECLARE
pIn ALIAS FOR $1;
BEGIN
insert into schema1.table values(pIn,0); --this is just an example :)
return 0;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
If I change the schema name using PGADMIN it just change this part:
CREATE OR REPLACE FUNCTION new_schema.example(double precision) RETURNS numeric AS
...........
I'm asking about any way to change the schema of the command inside of the code automatically, because I have many
stored procedure in the database (about 63) and this process could take so much time, I hope had been clear, sorry about
my bad english :S
for example:
I have this stored procedure:
CREATE OR REPLACE FUNCTION schema1.example(double precision) RETURNS numeric AS
$BODY$
DECLARE
pIn ALIAS FOR $1;
BEGIN
insert into schema1.table values(pIn,0); --this is just an example :)
return 0;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
If I change the schema name using PGADMIN it just change this part:
CREATE OR REPLACE FUNCTION new_schema.example(double precision) RETURNS numeric AS
...........
I'm asking about any way to change the schema of the command inside of the code automatically, because I have many
stored procedure in the database (about 63) and this process could take so much time, I hope had been clear, sorry about
my bad english :S
--
![](/media/maillist_attaches/pgsql-admin/2009/08/06/4A7B3BD9.5060402@ncq.co.cr/mmorales.jpg)
![](/media/maillist_attaches/pgsql-admin/2009/08/06/4A7B3BD9.5060402@ncq.co.cr/mmorales.jpg)
Вложения
Mainor Alonso Morales González wrote: > There exist any way to change the name of my stored procedures > schemas but the code used inside of them??? No. You could try doing an UPDATE to pg_proc with a query that changed the old schema for the new. > sorry about my bad english :S Perhaps you could use the pgsql-es-ayuda list, in any case. (Your english does not seem all that bad anyway). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From: Mainor Alonso Morales González <mmorales@ncq.co.cr> |