Обсуждение: 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