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-materialized-views/ 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? What might be the downsides of using ProgrammingError exception handling? try: CREATE MATERIALIZED VIEW AS SELECT ... except ProgrammingError: CREATE TABLE AS SELECT ... Are there any other options that would not require additional configuration variable on user's side? Regards, Stefan -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.