Re: Catching dangling LOBs?

Vitaly Belman <vitalyb(at)gmail(dot)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