From: | MirrorX <mirrorx(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | replace function, what happens afterwards? |
Date: | 2014-04-16 12:54:31 |
Message-ID: | 1397652871236-5800264.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
dear all,
i have a question regarding a recent problem that we faced and we are trying
to identify.
let's suppose we have a function A and a function B that in some point calls
function A.
function A->
…..
insert into table1(col1,col2) values ($1,$2)
…..
function B ->
…
select…
update….
insert….
select..
A();
….
Now function A is changed a bit, i.e we add a new argument in the insert
statement that it has (a constant). However this does not affect neither the
arguments of the function, nor the return type. And then function A is being
recompiled (with 'create or replace').
Afterwards, will function B keep working? Or we need to recomplie function B
as well (even if the code won't change)?
i am just trying to understand what is the default behaviour in this
situation
thank you in advance
--
View this message in context: http://postgresql.1045698.n5.nabble.com/replace-function-what-happens-afterwards-tp5800264.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2014-04-16 13:06:20 | Re: replace function, what happens afterwards? |
Previous Message | Dev Kumkar | 2014-04-16 12:24:23 | Re: Heartbleed Impact |