Thread

1. characters or bytes?

   Susanne Ebrecht <susanne@2ndquadrant.com> — 2011-03-26T22:20:41Z

   Hello,
   
   During translating start.sgml - I found a sentence where I am not sure
   if it is correct.
   
   tutorial-createdb.html
   
   Second paragraph below the "permission denied to create a database" 
   error message there is
   the sentence:
   
   " You can also create databases with other names. PostgreSQL allows
   you to create any number of databases at a given site. Database names
   must have an alphabetic first character and are limited to 63 characters
   in length. ..."
   
   Really 63 characters?
   Shouldn't it be 63 bytes?
   
   Susanne
   
   -- 
   Susanne Ebrecht - 2ndQuadrant
   PostgreSQL Development, 24x7 Support, Training and Services
   www.2ndQuadrant.com
   
   
   

2. patch for createdb section in tutorial

   Susanne Ebrecht <susanne@2ndquadrant.com> — 2011-03-27T10:41:45Z

   Hello,
   
   During translating the docs I found the following sentence
   in the tutorial section about createdb:
   
   "Database names must have an alphabetic first character
   and are limited to 63 characters"
   
   I wondered - really characters? shouldn't it be bytes?
   
   I just tested - creating a database by using German umlauts
   let me get sure - it are bytes not characters.
   
   Here is the patch with the correction - I just changed the word
   characters into bytes.
   
   Susanne
   
   -- 
   Susanne Ebrecht - 2ndQuadrant
   PostgreSQL Development, 24x7 Support, Training and Services
   www.2ndQuadrant.com
   
   

3. Re: patch for createdb section in tutorial

   Robert Haas <robertmhaas@gmail.com> — 2011-03-28T01:30:58Z

   On Sun, Mar 27, 2011 at 6:41 AM, Susanne Ebrecht
   <susanne@2ndquadrant.com> wrote:
   > Hello,
   >
   > During translating the docs I found the following sentence
   > in the tutorial section about createdb:
   >
   > "Database names must have an alphabetic first character
   > and are limited to 63 characters"
   >
   > I wondered - really characters? shouldn't it be bytes?
   >
   > I just tested - creating a database by using German umlauts
   > let me get sure - it are bytes not characters.
   >
   > Here is the patch with the correction - I just changed the word
   > characters into bytes.
   
   Committed and back-patched all the way.
   
   -- 
   Robert Haas
   EnterpriseDB: http://www.enterprisedb.com
   The Enterprise PostgreSQL Company
   
   

4. Re: characters or bytes?

   Bruce Momjian <bruce@momjian.us> — 2011-05-05T16:25:09Z

   Susanne Ebrecht wrote:
   > Hello,
   > 
   > During translating start.sgml - I found a sentence where I am not sure
   > if it is correct.
   > 
   > tutorial-createdb.html
   > 
   > Second paragraph below the "permission denied to create a database" 
   > error message there is
   > the sentence:
   > 
   > " You can also create databases with other names. PostgreSQL allows
   > you to create any number of databases at a given site. Database names
   > must have an alphabetic first character and are limited to 63 characters
   > in length. ..."
   > 
   > Really 63 characters?
   > Shouldn't it be 63 bytes?
   > 
   
   Susanne, not sure you received a reply, but the documention has been
   corrected to say "bytes".  Thanks.
   
   -- 
     Bruce Momjian  <bruce@momjian.us>        http://momjian.us
     EnterpriseDB                             http://enterprisedb.com
   
     + It's impossible for everything to be true. +
   
   

5. Re: characters or bytes?

   Susanne Ebrecht <susanne@2ndquadrant.com> — 2011-05-06T10:15:15Z

   On 05.05.2011 18:25, Bruce Momjian wrote:
   >> Really 63 characters?
   >> Shouldn't it be 63 bytes?
   >>
   > Susanne, not sure you received a reply, but the documention has been
   > corrected to say "bytes".  Thanks.
   
   Bruce,
   
   that is nice.
   I got the answer already a few minutes after asking.
   
   Anyway, thanks for taking care and replying,
   
   Susanne
   
   -- 
   Susanne Ebrecht - 2ndQuadrant
   PostgreSQL Development, 24x7 Support, Training and Services
   www.2ndQuadrant.com