Re: [sqlalchemy] oracle reflect with duplicated tables (schema casing)

2013-07-25 Thread Michael Bayer
On Jul 24, 2013, at 10:35 PM, Victor Olex victor.o...@vtenterprise.com wrote: Putting the weird aside, I am still puzzled why would the foreign key in MIKE.customer in the above example be seen as coming from mike.address and not MIKE.address? Shouldn't the schema name be consistent and

[sqlalchemy] oracle reflect with duplicated tables (schema casing)

2013-07-24 Thread mdob
Hi, I got into an interesting issue where I receive duplicated tables if I use capital letters schema in reflect method. Ubuntu 12.04 with packages oracle-instantclient11.2-basiclite-11.2.0.3.0-1.i386.rpm, oracle-instantclient11.2-devel-11.2.0.3.0-1.i386.rpm,

Re: [sqlalchemy] oracle reflect with duplicated tables (schema casing)

2013-07-24 Thread Michael Bayer
On Jul 24, 2013, at 7:34 PM, mdob mike.dobrzan...@gmail.com wrote: Hi, I got into an interesting issue where I receive duplicated tables if I use capital letters schema in reflect method. you wouldn't want to do that unless the table were actually created using a case-sensitive name,

Re: [sqlalchemy] oracle reflect with duplicated tables (schema casing)

2013-07-24 Thread Victor Olex
Hey Mike, thanks for chiming in. Popular tool Oracle SQL Develoepr generally produces DDL with quoted identifiers so in real life you will encounter a lot of situations where some tables were created using quoted and some unquoted as people work on maintaining the database. Using lowercase