Hi, I have now added test case with DATABASE_TO_UPPER=false, and have fixed the problems I found (changes are in the trunk). I didn't directly use your patch, so I'm not sure if the problem you reported is now completely fixed. Could you test it? If something is still not working, please extend the test case (TestPgServer.testLowerCaseIdentifiers) so we can see where it is failing.
Regards, Thomas On Mon, Nov 25, 2013 at 8:01 AM, Noel Grandin <[email protected]> wrote: > Hi > > Thanks for your patch. > > I'm not sure about the change to only return PUBLIC tables, but the rest > looks fine. > > Can we get a license statement? > http://h2database.com/html/build.html#providing_patches > > The catalog can only be installed when the first connection arrives > because it's only at that point in time that we receive the > db-name/username/password. > > Regards, Noel > > > On 2013-11-21 22:26, doozel wrote: > >> >> I need ODBC access for my application and PgServer does not work when you >> have DATABASE_TO_UPPER set to false (I am >> using JOOQ and was using a legacy database with mixed case). The problems >> are related to case sensitivity of schema >> names and roles. Attached is the PgServer with fixes to make it work. >> >> I have also change the table lookups to only return the PUBLIC tables. >> Hopefully someone else finds it useful. >> >> Only issue now is the need to be admin to access the PgServer , I imagine >> this is because the pg_catalog schema is >> created on the first connection to the server? This should be done when >> the pgserver starts up instead. I am not sure >> how to do that. >> >> > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
