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