[sqlalchemy] SA generates invalid SQL when creating tables in sqlite using (attached) schemata

Hi, this might be another small bug in SA. It shows up when an Sqlite db is composed of multiple sub-DBs via the 'attach' statement. This is useful for mimicking schemata and allows tables to be addressed like schema.table (using common dot-syntax). To make the following work run this statement

Re: [sqlalchemy] SA generates invalid SQL when creating tables in sqlite using (attached) schemata

On Jul 13, 2010, at 5:44 AM, Ralph Heinkel wrote: Hi, this might be another small bug in SA. It shows up when an Sqlite db is composed of multiple sub-DBs via the 'attach' statement. This is useful for mimicking schemata and allows tables to be addressed like schema.table (using common

Re: [sqlalchemy] SA generates invalid SQL when creating tables in sqlite using (attached) schemata

On Jul 13, 2010, at 10:31 AM, Michael Bayer wrote: On Jul 13, 2010, at 5:44 AM, Ralph Heinkel wrote: Hi, this might be another small bug in SA. It shows up when an Sqlite db is composed of multiple sub-DBs via the 'attach' statement. This is useful for mimicking schemata and allows