I've got a C function in a .so that I use in postgres. While developing it
I want to reload the dynamic library. The docs says that LOAD should do
the trick but nothing happens when I use it.
Have LOAD stoped working and is it now a NOP?
I've tried LOAD both when the function exists in pg, and
My plpgsql function seems to be ignoring search_path when looking for
the right table to select from. I'm running 7.3.4. Below is my test
code. Am I doing something wrong?
TIA, Gene Chow
test=> create or replace function getval() returns varchar as '
test'> declare val varchar;
test'> begin
tes
Not my place to say, but...
I think this likely should be worded something like this (if true):
...
Also note that the current_timestamp family of functions qualify as stable,
since their values do not change within SQL statement, and to be more
concise the current_timestamp functions do not chang
I think the problem is that the first time the function is called, it is
compiled and cached for later use. At that time the function is bound
to the table oid, so even though you change the search path, the cached
copy still calls the old table.
If you exit psql and re-enter, or change the sche
Bruce Momjian <[EMAIL PROTECTED]> writes:
> This highlights another problem with our plpgsql function caching.
It's a little disturbing to think that any change in SEARCH_PATH might
force us to discard all cached plans. That could be expensive; and
consider a function that deliberately sets SEARC
Eugene Chow wrote:
> Thanks. If I had only read the manual before posting. I solved it by
> using 'execute' instead of 'select into' since the search_path is not
> static in my system.
Yep, that's the workaround mentioned in the FAQ.
--
Bruce Momjian| http://candle
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > This highlights another problem with our plpgsql function caching.
>
> It's a little disturbing to think that any change in SEARCH_PATH might
> force us to discard all cached plans. That could be expensive; and
> consider a function
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> I've got a C function in a .so that I use in postgres. While developing it
> I want to reload the dynamic library. The docs says that LOAD should do
> the trick but nothing happens when I use it.
You're right, this seems not to work on Linux. I've
