how to reload a function

From: Jie Liang <jliang(at)ipinc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'PostgreSQL Admin News'" <pgsql-admin(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org
Subject: how to reload a function
Date: 2001-03-07 18:05:13
Message-ID: Pine.BSF.4.10.10103070954550.55820-100000@tidal.ipinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql


I have 2 plpgsql defined functions, say:

create function A(....) returns ... as'
.....
'language 'plpgsql';

create function B(....) returns ... as '
declare
....
begin
select A(..) into myvar from ....
....
end;
'language 'plpgsql';

If I modify function A (drop && re_create), then I have to re_create
function B though no change to function B.

Is there any way (sql stmt) let me re_load function B's defination
without using drop and create??

Thanks.

Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message bangh 2001-03-07 19:37:57 Re: Postgresql \z grant question
Previous Message Lamar Owen 2001-03-07 17:13:40 Re: Postgres/Postmaster logging and log rotation

Browse pgsql-sql by date

  From Date Subject
Next Message Kevin T. Manley (Home) 2001-03-07 18:12:18 Re: SQL problem
Previous Message Jie Liang 2001-03-07 17:09:32 how to get info of function