Re: [BUGS] vacuumlo fails in the presence of a index on expression - demo sql included

Frank van Vugt <[EMAIL PROTECTED]> writes: > CREATE FUNCTION get_level(varchar) RETURNS int LANGUAGE 'sql' IMMUTABLE STRICT > SECURITY INVOKER AS 'SELECT id FROM level WHERE abbreviation = $1'; The bug is in this function: it's assuming that "level" will always be in the current search path. Per

[BUGS] vacuumlo fails in the presence of a index on expression - demo sql included

L.S. I don't expect that this is the intended behaviour: db=# SELECT version(); version - PostgreSQL 7.4.3 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66 If you run these commands: CREATE TA