Re: [sqlalchemy] How to get server or dialect version or properties?

2013-04-13 Thread Stefan Urbanek
Thank you, this solves my problem. On Saturday, April 13, 2013 2:53:15 PM UTC-5, Michael Bayer wrote: > > there should be engine.dialect.server_version_info available, once at > least one connection has been made. > > > > > On Apr 13, 2013, at 12:26 PM, Stefan Urbanek > > > wrote: > > Hi, > > I

Re: [sqlalchemy] How to get server or dialect version or properties?

2013-04-13 Thread Michael Bayer
there should be engine.dialect.server_version_info available, once at least one connection has been made. On Apr 13, 2013, at 12:26 PM, Stefan Urbanek wrote: > Hi, > > In Cubes I would like to optionally use the upcoming CREATE MATERIALIZED VIEW > [1] feature in Postgres 9.3 (or any other

[sqlalchemy] Re: How to get server or dialect version or properties?

2013-04-13 Thread Lele Gaifax
Stefan Urbanek writes: > Is there some "correct" way how I can determine version of the server or at > least some list of properties from which I can determine existence of such > functionality? I used something like the following: cursor.execute("SELECT version()") v = cursor.fetchon

[sqlalchemy] How to get server or dialect version or properties?

2013-04-13 Thread Stefan Urbanek
Hi, In Cubes I would like to optionally use the upcoming CREATE MATERIALIZED VIEW [1] feature in Postgres 9.3 (or any other database that supports it). There will be plain alternative "CREATE TABLE" for Postgres < 9.3. [1] http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-m

[sqlalchemy] Re: MetaBase.create_all broken on parallel execution

2013-04-13 Thread David Lemayian
This happened to me as well. Happened after installing libsqlite3-dev. Fixed by running apt-get remove libsqlite3-dev . Best, David. On Thursday, 8 November 2012 10:19:06 UTC+3, Eugeny Klementev wrote: > > Hi all, > > I use sqlalchemy with postgresql backend. > > On script starting i use code