problem with gnucash and postgresql

[Phil Longstaff]

On Wed, 2010-09-01 at 09:44 +1200, Bopolissimus Platypus Jr wrote:
> On Tue, Aug 31, 2010 at 2:42 AM, Md. Aminul Islam Khan
> <aikhanlab at gmail.com> wrote:
> > Using Ubuntu-9.04.
> > Installed postgresql-9.0beta4, and gnucash-2.3.15.
> > Save as: Postgres -> dialogue box:
> > Host: localhost,
> > Database:
> >         if name contains capital letter (e.g. Finance) it gives error or
> > corrupt file.
> >         if name in all small letters (e.g. finance) database is created.
> >
> > Reason?
> 
> It's a postgres feature.  tablenames, if not enclosed in double
> quotes, are automatically folded to lower case.  if your table has
> upper case letters (or is a keyword) then tablenames need to be
> enclosed in double quotes in the SQL sent to the database backend.
> 
> some discussion here:
> 
> http://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/PostgreSQL_x1428_003.htm

Thanks.  I haven't checked the reference, but do you know if it applies
to database names as well?  gnucash uses only lower case for table
names, and this refers to the database name.

Phil