Re: Catching dangling LOBs?

That was the problem. Thanks =).

P.S Still a bit strange because "functions" IS in the search_path,
there is no reason for it not to find it from the vacuum.

On 4/16/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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
>

--
ICQ: 1912453
AIM: VitalyB1984
MSN: tmdagent(at)hotmail(dot)com
Yahoo!: VitalyBe