problem with gnucash and postgresql

[Bopolissimus Platypus Jr]

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

tiger

-- 
Gerald Timothy Quimpo http://bopolissimus.blogspot.com
bopolissimus.lists at gmail.com bopolissimus at gmail.com

Even Tom Lane said: "Or, if you're worried
about actions from functions, use a trigger
to do the logging.  There are approximately
no cases where a rule is really better than
a trigger :-( "