After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 589103 - GdaServerProvider requires quoted table names and field names.
GdaServerProvider requires quoted table names and field names.
Status: RESOLVED DUPLICATE of bug 589102
Product: libgda
Classification: Other
Component: PostgreSQL provider
4.1.x
Other Linux
: Normal normal
: ---
Assigned To: malerba
gnome-db Maintainers
Depends on:
Blocks:
 
 
Reported: 2009-07-20 09:05 UTC by Murray Cumming
Modified: 2009-07-20 09:06 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Murray Cumming 2009-07-20 09:05:29 UTC 
This test case shows that using GDA_SERVER_OPERATION_CREATE_TABLE and GDA_SERVER_OPERATION_ADD_COLUMN currently requires mixed-case SQL identifiers to be quoted. If not, lowercase table names or field names are created, as can be seen in PgAdmin3, for instance.

This is not a problem with the SQLite provider, as you can see by commenting out the alternative connection line.

Vivien mentioned on the mailing list that quoting should not be necessary with this API.
Comment 1 Murray Cumming 2009-07-20 09:06:01 UTC 

*** This bug has been marked as a duplicate of 589102 ***