aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2011-03-11 08:47:44 -0500
committerBruce Momjian <bruce@momjian.us>2011-03-11 08:47:44 -0500
commit35a1964e557ad5993a94e8b800135f55b6347926 (patch)
tree481ed154170031ed26f80c235ebd1dd19ccc4242
parentcbd2811461daf2c6b71d56048b96374cc2d61d64 (diff)
downloadpostgresql-35a1964e557ad5993a94e8b800135f55b6347926.tar.gz
postgresql-35a1964e557ad5993a94e8b800135f55b6347926.zip
In plpsql docs, use RAISE rather than undefined log function.
-rw-r--r--doc/src/sgml/plpgsql.sgml7
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;