diff options
author | Bruce Momjian <bruce@momjian.us> | 2011-03-11 08:47:44 -0500 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2011-03-11 08:47:44 -0500 |
commit | 35a1964e557ad5993a94e8b800135f55b6347926 (patch) | |
tree | 481ed154170031ed26f80c235ebd1dd19ccc4242 | |
parent | cbd2811461daf2c6b71d56048b96374cc2d61d64 (diff) | |
download | postgresql-35a1964e557ad5993a94e8b800135f55b6347926.tar.gz postgresql-35a1964e557ad5993a94e8b800135f55b6347926.zip |
In plpsql docs, use RAISE rather than undefined log function.
-rw-r--r-- | doc/src/sgml/plpgsql.sgml | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml index d0672bbc89a..8da093b7384 100644 --- a/doc/src/sgml/plpgsql.sgml +++ b/doc/src/sgml/plpgsql.sgml @@ -2169,21 +2169,20 @@ CREATE FUNCTION cs_refresh_mviews() RETURNS integer AS $$ DECLARE mviews RECORD; BEGIN - PERFORM cs_log('Refreshing materialized views...'); + RAISE NOTICE 'Refreshing materialized views...'; FOR mviews IN SELECT * FROM cs_materialized_views ORDER BY sort_key LOOP -- Now "mviews" has one record from cs_materialized_views - PERFORM cs_log('Refreshing materialized view ' - || quote_ident(mviews.mv_name) || ' ...'); + RAISE NOTICE 'Refreshing materialized view %s ...', quote_ident(mviews.mv_name); EXECUTE 'TRUNCATE TABLE ' || quote_ident(mviews.mv_name); EXECUTE 'INSERT INTO ' || quote_ident(mviews.mv_name) || ' ' || mviews.mv_query; END LOOP; - PERFORM cs_log('Done refreshing materialized views.'); + RAISE NOTICE 'Done refreshing materialized views.'; RETURN 1; END; $$ LANGUAGE plpgsql; |