diff options
| author | Bruce Momjian <bruce@momjian.us> | 2011-03-15 11:26:20 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2011-03-15 11:26:57 -0400 |
| commit | ddd6ff289f2512f881493b7793853a96955459ff (patch) | |
| tree | 2795b3bed7e14bffe4d0a747a82bed0afcc368d2 /src | |
| parent | f0f3617135854281bdb79179a895c102d54cb95b (diff) | |
| download | postgresql-ddd6ff289f2512f881493b7793853a96955459ff.tar.gz postgresql-ddd6ff289f2512f881493b7793853a96955459ff.zip | |
Add database comments to template0 and postgres databases, and improve
the comments on the template1 database. No catalog version bump because
they are just comments.
Diffstat (limited to 'src')
| -rw-r--r-- | src/bin/initdb/initdb.c | 3 | ||||
| -rw-r--r-- | src/include/catalog/pg_database.h | 2 |
2 files changed, 4 insertions, 1 deletions
diff --git a/src/bin/initdb/initdb.c b/src/bin/initdb/initdb.c index f6cf3772822..7a4b698b99f 100644 --- a/src/bin/initdb/initdb.c +++ b/src/bin/initdb/initdb.c @@ -1976,6 +1976,8 @@ make_template0(void) "REVOKE CREATE,TEMPORARY ON DATABASE template1 FROM public;\n", "REVOKE CREATE,TEMPORARY ON DATABASE template0 FROM public;\n", + "COMMENT ON DATABASE template0 IS 'unmodifiable empty database';\n", + /* * Finally vacuum to clean up dead rows in pg_database */ @@ -2011,6 +2013,7 @@ make_postgres(void) const char **line; static const char *postgres_setup[] = { "CREATE DATABASE postgres;\n", + "COMMENT ON DATABASE postgres IS 'default administrative connection database';\n", NULL }; diff --git a/src/include/catalog/pg_database.h b/src/include/catalog/pg_database.h index 6419d656827..ee4c8582afe 100644 --- a/src/include/catalog/pg_database.h +++ b/src/include/catalog/pg_database.h @@ -71,7 +71,7 @@ typedef FormData_pg_database *Form_pg_database; #define Anum_pg_database_datacl 12 DATA(insert OID = 1 ( template1 PGUID ENCODING "LC_COLLATE" "LC_CTYPE" t t -1 0 0 1663 _null_)); -SHDESCR("default template database"); +SHDESCR("default template for new databases"); #define TemplateDbOid 1 #endif /* PG_DATABASE_H */ |