Re: [sqlalchemy] mssql and specifying a schema name?

. -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries

Re: [sqlalchemy] LONGVARCHAR

question the design decision. Michael -- Michael Schlenker Software Architect CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen

Re: [sqlalchemy] Why my python script can use in the server but not from the client machine?

on your machine, try to see which tickets you have. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der

[sqlalchemy] Re: app memory leak - execute() with SA 0.5.2, PG 8.3, Psycopg2

-- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de/ E-Mail: m...@contact.de Sitz der Gesellschaft: Bremen Geschäftsführer: Karl Heinz Zachries, Ralf

[sqlalchemy] COMMENT ON clause for schema.Column/schema.Table?

/B19306_01/server.102/b14200/statements_4009.htm#i2119719, SQL Server supports something similar, and Postgresql too http://www.postgresql.org/docs/8.3/interactive/sql-comment.html) Would be nice to be able to reflect a docstring into the database schema that way. Michael -- Michael Schlenker

[sqlalchemy] Adding text() at the end of an sql.expression?

addtl = some sql stuff and i want it to transform to: SELECT test.foo, test.bar FROM test WHERE foo=20 some sql stuff So i try to find a good way to tack such a SQL string at the end of a sqlexpression, but haven't seen it yet. Is there a way? Michael -- Michael Schlenker Software Engineer

[sqlalchemy] Re: SQLAlchemy 0.4.2b released

, but to 30 characters. Unless he is using Oracle with NLS_LENGTH_SEMANTICS as Bytes..., then its really Bytes..., but thats a bad setting for various reasons. Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax

[sqlalchemy] Oracle date/datetime oddities

is there and is returned correctly by cx_Oracle. I would expect to get at least identity for this. So is this a bug and should i add a report or is it a 'feature' of some kind and will not change even if i report a bug? Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH

[sqlalchemy] Re: Oracle date/datetime oddities

Michael Bayer schrieb: On Nov 12, 2007, at 11:16 AM, Michael Schlenker wrote: Hi all, your above test means to say if r[0]==now:, else you get a runtime error. Right, should copy and paste instead of retype... When I run it with that fix, the row matches and it prints Found

[sqlalchemy] MetaData reflect on Oracle with multiple visible tables

on the Table class, but how can i specify an owner for reflection as requested by the Exception? Michael -- Michael Schlenker Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41 28359 Bremen http://www.contact.de

[sqlalchemy] Re: MetaData reflect on Oracle with multiple visible tables

Michael Bayer schrieb: On Nov 5, 2007, at 6:44 AM, Michael Schlenker wrote: I tried with: meta.reflect(schema=msc_ora1) but it raises the same exception. I have noticed the 'owner' attribute on the Table class, but how can i specify an owner for reflection as requested