Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: PostgreSQL case sensitive queries

  1. #1
    Join Date
    Dec 2010
    Posts
    304

    Default PostgreSQL case sensitive queries

    Hi all,
    since I work with Postgres, the names of tables and fields in my schema have to be in lower case, otherwise I get an error.
    Is there a way to configure Modrian or Postgres or JDBC driver in order to run case insensitive queries?
    Thanks

  2. #2
    Join Date
    Mar 2007
    Posts
    142

    Default

    Mondrian's only parameter regarding case sensitivity is related to the MDX parser. Besides that, it shouldn't tamper with the case used in the schema. If you can reproduce a case where Mondrian changes the case of something defined in the schema, let us know. That would be a bug.
    Luc Boudreau
    aka. Luc le Magnifique
    aka. Monsieur Oui Oui

    Lead Engineer, Pentaho Corporation
    Web: http://devdonkey.blogspot.com
    Twitter: luclemagnifique
    IRC: Monsieur_Oui_Oui@freenode

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.