diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-04-26 22:50:17 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-04-26 22:50:17 +0000 |
| commit | 525de8d55653a2ff995350d64cc1fe9a9f87afad (patch) | |
| tree | dc57cd8fe42f2018f6d05a1a6df2ab404da67002 /contrib/pg_buffercache/pg_buffercache.sql.in | |
| parent | 136bea1540e02dc8cdd8e1089808f96885a1751f (diff) | |
| download | postgresql-525de8d55653a2ff995350d64cc1fe9a9f87afad.tar.gz | |
Improve /contrib/pg_buffercache installation to use BEGIN/COMMIT,
improve examples.
Mark Kirkwood
Diffstat (limited to 'contrib/pg_buffercache/pg_buffercache.sql.in')
| -rw-r--r-- | contrib/pg_buffercache/pg_buffercache.sql.in | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/contrib/pg_buffercache/pg_buffercache.sql.in b/contrib/pg_buffercache/pg_buffercache.sql.in index 85c7b2869a..ea63234f6b 100644 --- a/contrib/pg_buffercache/pg_buffercache.sql.in +++ b/contrib/pg_buffercache/pg_buffercache.sql.in @@ -1,4 +1,5 @@ -- Adjust this setting to control where the objects get created. +BEGIN; SET search_path = public; -- Register the function. @@ -16,3 +17,5 @@ CREATE VIEW pg_buffercache AS -- Don't want these to be available at public. REVOKE ALL ON FUNCTION pg_buffercache_pages() FROM PUBLIC; REVOKE ALL ON pg_buffercache FROM PUBLIC; + +COMMIT; |