[jira] [Commented] (CAY-2147) Error Generating DB Schema for postgresql database

["Nikita Timofeev (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAY-2147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15686727#comment-15686727 ] 

Nikita Timofeev commented on CAY-2147:
--------------------------------------

The problem is in schema camelCase naming as driver converts unquoted identifiers to lowercase.
However "Quote SQL Identifiers" checkbox in DataMap settings fixes this. When it's "on" this query is executed without error.


> Error Generating DB Schema for postgresql database
> --------------------------------------------------
>
>                 Key: CAY-2147
>                 URL: https://issues.apache.org/jira/browse/CAY-2147
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Modeler
>    Affects Versions: 4.0.M4
>            Reporter: ana benko
>            Assignee: Nikita Timofeev
>
> 1. Import postgresql db. Save
> 2. Run Generate DB Schema. Select 'Drop Tables'
> 3. Select connection to postgresql db (in my case: jdbc:postgresql://localhost:5432/postgresTest)
> 4. Generate
> -> error appears
> [SQL: DROP TABLE forCayenne.painting CASCADE] - ERROR: schema "forcayenne" does not exist
> forCayenne is my db schema in postgresTest db



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)