Re: [HACKERS] template0 database comment

2011-03-15 Thread Bruce Momjian
Applied. I did not bump the catalog version because they are just comments. I assume that is the right procedure. --- Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Tom Lane wrote:

Re: [HACKERS] template0 database comment

2011-03-15 Thread Thom Brown
On 15 March 2011 15:26, Bruce Momjian br...@momjian.us wrote: Applied.  I did not bump the catalog version because they are just comments.  I assume that is the right procedure. *SNIP* +             COMMENT ON DATABASE postgres IS 'default administrative connection database';\n, Default

Re: [HACKERS] template0 database comment

2011-03-15 Thread Bruce Momjian
Thom Brown wrote: On 15 March 2011 15:26, Bruce Momjian br...@momjian.us wrote: Applied. ?I did not bump the catalog version because they are just comments. ?I assume that is the right procedure. *SNIP* + ? ? ? ? ? ? COMMENT ON DATABASE postgres IS 'default administrative

Re: [HACKERS] template0 database comment

2011-03-15 Thread Thom Brown
On 15 March 2011 15:37, Bruce Momjian br...@momjian.us wrote: Thom Brown wrote: On 15 March 2011 15:26, Bruce Momjian br...@momjian.us wrote: Applied. ?I did not bump the catalog version because they are just comments. ?I assume that is the right procedure. *SNIP* + ? ? ? ? ? ?

Re: [HACKERS] template0 database comment

2011-03-15 Thread Thom Brown
On 15 March 2011 15:51, Thom Brown t...@linux.com wrote: On 15 March 2011 15:37, Bruce Momjian br...@momjian.us wrote: Thom Brown wrote: On 15 March 2011 15:26, Bruce Momjian br...@momjian.us wrote: Applied. ?I did not bump the catalog version because they are just comments. ?I assume

Re: [HACKERS] template0 database comment

2011-03-15 Thread David Fetter
On Sat, Mar 12, 2011 at 09:24:38PM +, Greg Stark wrote: On Sat, Mar 12, 2011 at 8:42 PM, Robert Haas robertmh...@gmail.com wrote: A preposition is something you should try not to end a sentence with. Something to keep in mind when someone localises Postgres for Latin which has this

Re: [HACKERS] template0 database comment

2011-03-15 Thread Bruce Momjian
Thom Brown wrote: On 15 March 2011 15:51, Thom Brown t...@linux.com wrote: On 15 March 2011 15:37, Bruce Momjian br...@momjian.us wrote: Thom Brown wrote: On 15 March 2011 15:26, Bruce Momjian br...@momjian.us wrote: Applied. ?I did not bump the catalog version because they are just

Re: [HACKERS] template0 database comment

2011-03-14 Thread Bruce Momjian
Tom Lane wrote: Greg Stark gsst...@mit.edu writes: On Sat, Mar 12, 2011 at 1:59 PM, Bruce Momjian br...@momjian.us wrote: OK, funny guys. ;-) Can someone give me the right text. Obviously I don' know what template0 is used for either. Is it pg_dumpall perhaps? template0:

Re: [HACKERS] template0 database comment

2011-03-14 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Tom Lane wrote: Yeah, I think that the right way to approach this is to have initdb comment *both* of those databases. I don't like that specific wording for template0 though. Maybe template0: unmodified copy of original template1 database

Re: [HACKERS] template0 database comment

2011-03-14 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Tom Lane wrote: Yeah, I think that the right way to approach this is to have initdb comment *both* of those databases. I don't like that specific wording for template0 though. Maybe template0: unmodified copy of original

Re: [HACKERS] template0 database comment

2011-03-14 Thread Bruce Momjian
Peter Eisentraut wrote: On l?r, 2011-03-12 at 12:01 -0500, Tom Lane wrote: Shouldn't the postgres database get a comment too, while we're at it? Perhaps default database to connect to? That's not actually true, though. Maybe it's the default database used by administration programs? In

[HACKERS] template0 database comment

2011-03-12 Thread Bruce Momjian
People are confused about what template0 is for, so I created the attached one-line patch to add a database comment to template0. No initdb, I assume, becuase it is just a comment. I plan to work on more system table and view comments for 9.2. -- Bruce Momjian br...@momjian.us

Re: [HACKERS] template0 database comment

2011-03-12 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: People are confused about what template0 is for, so I created the attached one-line patch to add a database comment to template0. No initdb, I assume, becuase it is just a comment. + COMMENT ON DATABASE template0 IS 'only used by

Re: [HACKERS] template0 database comment

2011-03-12 Thread Dave Page
On 3/12/11, Tom Lane t...@sss.pgh.pa.us wrote: Bruce Momjian br...@momjian.us writes: People are confused about what template0 is for, so I created the attached one-line patch to add a database comment to template0. No initdb, I assume, becuase it is just a comment. +COMMENT ON

Re: [HACKERS] template0 database comment

2011-03-12 Thread Bruce Momjian
Dave Page wrote: On 3/12/11, Tom Lane t...@sss.pgh.pa.us wrote: Bruce Momjian br...@momjian.us writes: People are confused about what template0 is for, so I created the attached one-line patch to add a database comment to template0. No initdb, I assume, becuase it is just a comment. +

Re: [HACKERS] template0 database comment

2011-03-12 Thread Thom Brown
On 12 March 2011 13:59, Bruce Momjian br...@momjian.us wrote: Dave Page wrote: On 3/12/11, Tom Lane t...@sss.pgh.pa.us wrote: Bruce Momjian br...@momjian.us writes: People are confused about what template0 is for, so I created the attached one-line patch to add a database comment to

Re: [HACKERS] template0 database comment

2011-03-12 Thread Bruce Momjian
Thom Brown wrote: On 12 March 2011 13:59, Bruce Momjian br...@momjian.us wrote: Dave Page wrote: On 3/12/11, Tom Lane t...@sss.pgh.pa.us wrote: Bruce Momjian br...@momjian.us writes: People are confused about what template0 is for, so I created the attached one-line patch to add a

Re: [HACKERS] template0 database comment

2011-03-12 Thread Christopher Browne
On Sat, Mar 12, 2011 at 8:59 AM, Bruce Momjian br...@momjian.us wrote: Dave Page wrote: On 3/12/11, Tom Lane t...@sss.pgh.pa.us wrote: Bruce Momjian br...@momjian.us writes: People are confused about what template0 is for, so I created the attached one-line patch to add a database comment

Re: [HACKERS] template0 database comment

2011-03-12 Thread Christopher Browne
On Sat, Mar 12, 2011 at 9:14 AM, Bruce Momjian br...@momjian.us wrote: I like that.  Perhaps unmodified template database'? why tends to be more important than what, particularly to a confused DBA who's trying to figure out why do they have all these extra databases??? Perhaps... backup

Re: [HACKERS] template0 database comment

2011-03-12 Thread Bruce Momjian
Christopher Browne wrote: On Sat, Mar 12, 2011 at 8:59 AM, Bruce Momjian br...@momjian.us wrote: Dave Page wrote: On 3/12/11, Tom Lane t...@sss.pgh.pa.us wrote: Bruce Momjian br...@momjian.us writes: People are confused about what template0 is for, so I created the attached one-line

Re: [HACKERS] template0 database comment

2011-03-12 Thread Greg Stark
On Sat, Mar 12, 2011 at 1:59 PM, Bruce Momjian br...@momjian.us wrote: OK, funny guys.  ;-)  Can someone give me the right text.  Obviously I don' know what template0 is used for either.  Is it pg_dumpall perhaps? template0: unmodifiable pristine empty database template1: default template for

Re: [HACKERS] template0 database comment

2011-03-12 Thread Bruce Momjian
Greg Stark wrote: On Sat, Mar 12, 2011 at 1:59 PM, Bruce Momjian br...@momjian.us wrote: OK, funny guys. ?;-) ?Can someone give me the right text. ?Obviously I don' know what template0 is used for either. ?Is it pg_dumpall perhaps? template0: unmodifiable pristine empty database

Re: [HACKERS] template0 database comment

2011-03-12 Thread Tom Lane
Greg Stark gsst...@mit.edu writes: On Sat, Mar 12, 2011 at 1:59 PM, Bruce Momjian br...@momjian.us wrote: OK, funny guys. ;-) Can someone give me the right text. Obviously I don' know what template0 is used for either. Is it pg_dumpall perhaps? template0: unmodifiable pristine empty

Re: [HACKERS] template0 database comment

2011-03-12 Thread Peter Eisentraut
On lör, 2011-03-12 at 12:01 -0500, Tom Lane wrote: Shouldn't the postgres database get a comment too, while we're at it? Perhaps default database to connect to? That's not actually true, though. Maybe it's the default database used by administration programs? In practice it might be some

Re: [HACKERS] template0 database comment

2011-03-12 Thread Greg Stark
On Sat, Mar 12, 2011 at 5:01 PM, Tom Lane t...@sss.pgh.pa.us wrote: The problem with Greg's wording is that it's falsifiable: it is possible for someone to modify template0 if they're determined to mess things up. So a description like unmodifiable is promising too much. Eh, it's possible for

Re: [HACKERS] template0 database comment

2011-03-12 Thread Robert Haas
On Mar 12, 2011, at 12:01 PM, Tom Lane t...@sss.pgh.pa.us wrote: Greg Stark gsst...@mit.edu writes: On Sat, Mar 12, 2011 at 1:59 PM, Bruce Momjian br...@momjian.us wrote: OK, funny guys. ;-) Can someone give me the right text. Obviously I don' know what template0 is used for either. Is it

Re: [HACKERS] template0 database comment

2011-03-12 Thread Greg Stark
On Sat, Mar 12, 2011 at 8:42 PM, Robert Haas robertmh...@gmail.com wrote: A preposition is something you should try not to end a sentence with. Something to keep in mind when someone localises Postgres for Latin which has this rule. -- greg -- Sent via pgsql-hackers mailing list

Re: [HACKERS] template0 database comment

2011-03-12 Thread Andrew Dunstan
On 03/12/2011 04:24 PM, Greg Stark wrote: On Sat, Mar 12, 2011 at 8:42 PM, Robert Haasrobertmh...@gmail.com wrote: A preposition is something you should try not to end a sentence with. Something to keep in mind when someone localises Postgres for Latin which has this rule. I assume