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
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 |
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 |