diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-11-11 03:25:35 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-11-11 03:25:35 +0000 |
| commit | 926bbab44832ae2763392077ecefa029d14c8544 (patch) | |
| tree | e70fd1806e8a04b019808e1c71428568eb900f8c /contrib/pg_buffercache | |
| parent | 541ff409cc341ce1e0212fc6a7d67eef6709b6b4 (diff) | |
| download | postgresql-926bbab44832ae2763392077ecefa029d14c8544.tar.gz | |
Make /contrib install/uninstall script consistent:
remove transactions
use create or replace function
make formatting consistent
set search patch on first line
Add documentation on modifying *.sql to set the search patch, and
mention that major upgrades should still run the installation scripts.
Some of these issues were spotted by Tom today.
Diffstat (limited to 'contrib/pg_buffercache')
| -rw-r--r-- | contrib/pg_buffercache/pg_buffercache.sql.in | 3 | ||||
| -rw-r--r-- | contrib/pg_buffercache/uninstall_pg_buffercache.sql | 2 |
2 files changed, 1 insertions, 4 deletions
diff --git a/contrib/pg_buffercache/pg_buffercache.sql.in b/contrib/pg_buffercache/pg_buffercache.sql.in index a96b5d91f6..6ee320767a 100644 --- a/contrib/pg_buffercache/pg_buffercache.sql.in +++ b/contrib/pg_buffercache/pg_buffercache.sql.in @@ -1,5 +1,4 @@ -- Adjust this setting to control where the objects get created. -BEGIN; SET search_path = public; -- Register the function. @@ -17,5 +16,3 @@ 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; diff --git a/contrib/pg_buffercache/uninstall_pg_buffercache.sql b/contrib/pg_buffercache/uninstall_pg_buffercache.sql index 4c0c25ad79..601e8878bf 100644 --- a/contrib/pg_buffercache/uninstall_pg_buffercache.sql +++ b/contrib/pg_buffercache/uninstall_pg_buffercache.sql @@ -1,4 +1,4 @@ --- Adjust this setting to control where the objects get created. +-- Adjust this setting to control where the objects get dropped. SET search_path = public; DROP VIEW pg_buffercache; |