REINDEX inside plpgsql function

Hi,

Is it possible to use REINDEX TABLE inside plpgsql functions? Using it
inside a plpgsql block causes an error: 'The tuple isn't committed'. A
Google search on the error returned precisely 0 results ;-)

Postgres 7.2.1 on Linux/RH7.2

-- function definition
CREATE FUNCTION refresh_rcsdata(text) RETURNS int4 AS '
DECLARE
filename ALIAS FOR $1;

BEGIN

-- remove all data from rcsdata table
TRUNCATE TABLE rcsdata;

-- load new data and reindex
EXECUTE ''COPY rcsdata FROM '' || quote_literal(filename) || '' USING
DELIMITERS ''''\t'''' '';
REINDEX TABLE rcsdata;
RETURN 1;

END;
' LANGUAGE 'plpgsql';

thanks,
ben

--
benedict ausden
senior developer, navyblue new media
[t] 0131 553 0100
[e] benedict (a t) navyblue.com

www.navyblue.com
Scottish Design Consultancy of the Year 2002