After seeing the announcement for Amazon Redshift yesterday I thought I would see how hard it's going to be to connect from psycopyg/SqlAlchemy. So far I'm not having any luck. Below is what I'm trying and the error that follows:
engine = create_engine(URL('postgres', **options), poolclass=NullPool, execution_options={'no_parameters': True}) conn = engine.connect() Traceback (most recent call last): File "redshift.py", line 14, in <module> conn = engine.connect() File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2472, in connect return self._connection_cls(self, **kwargs) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 878, in __init__ self.__connection = connection or engine.raw_connection() File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 2558, in raw_connection return self.pool.unique_connection() File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/pool.py", line 183, in unique_connection return _ConnectionFairy(self).checkout() File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/pool.py", line 387, in __init__ rec = self._connection_record = pool._do_get() File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/pool.py", line 802, in _do_get return self._create_connection() File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/pool.py", line 188, in _create_connection return _ConnectionRecord(self) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/pool.py", line 273, in __init__ pool.dispatch.first_connect.exec_once(self.connection, self) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/event.py", line 282, in exec_once self(*args, **kw) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/event.py", line 291, in __call__ fn(*args, **kw) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/strategies.py", line 167, in first_connect dialect.initialize(c) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/dialects/postgresql/base.py", line 1000, in initialize super(PGDialect, self).initialize(connection) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 171, in initialize self._get_server_version_info(connection) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/dialects/postgresql/base.py", line 1184, in _get_server_version_info v = connection.execute("select version()").scalar() File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1449, in execute params) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1628, in _execute_text statement, parameters File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context context) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1685, in _execute_context context) File "/Users/matt/envs/health/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 334, in do_execute_no_params cursor.execute(statement) sqlalchemy.exc.ProgrammingError: (ProgrammingError) permission denied to set parameter "transaction_isolation" to "serializable" 'select version()' {} Any ideas? thanks, Matt -- 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.