Re: Catching dangling LOBs?

Vitaly Belman <vitalyb@gmail.com> writes:
> My bad. Here we go, really simple:

> CREATE OR REPLACE FUNCTION public.bayes_books(float4, int4)
>   RETURNS float8 AS
> 'select bayes($1, $2, 5, 3.9)'
   ^^^^^^^^^^^^
>   LANGUAGE 'sql' IMMUTABLE;

> CREATE OR REPLACE FUNCTION functions.bayes(float4, int4, int4, float4)
                             ^^^^^^^^^^^^^^^
>   RETURNS float8 AS
> 'select ($2 / ($2+$3::float4)) * $1 + ($3 / ($2+$3::float4)) * $4'
>   LANGUAGE 'sql' IMMUTABLE;

I'll bet that the "functions" schema wasn't in your search path when you
did the VACUUM.  It would be wiser to write "functions.bayes(...)" in
the bayes_books function, so it wouldn't be context-dependent.

            regards, tom lane