[Gambas-user] [Gambas Bug Tracker] Bug #1296: not able to use db.find or sql.request with postgreSQL

bugtracker at gambaswiki.org bugtracker at gambaswiki.org
Mon Apr 16 17:00:16 CEST 2018


http://gambaswiki.org/bugtracker/edit?object=BUG.1296&from=L21haW4-

Comment #9 by Benoît MINISINI:

The other problem with PostgreSQL is that you have to quote field or table names as soon as they are defined in upper case. Otherwise PostgreSQL seems to convert them to lower case.

"Quoting an identifier also makes it case-sensitive, whereas unquoted names are always folded to lower case." says the PostgreSQL documentation.

It seems weird to me, but it would explain the errors you get.

Benoît MINISINI changed the state of the bug to: NeedsInfo.




More information about the User mailing list