StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>edit: update for vertica 5/6 can be found here <a href="https://github.com/serbaut/psycopg2" rel="nofollow noreferrer">https://github.com/serbaut/psycopg2</a></p> <p>Here is a patch to make psycopg2 2.2.1 work with vertica 4.0. No ODBC needed.</p> <pre><code>diff --git a/psycopg/connection_int.c b/psycopg/connection_int.c index 902fdbb..b07eee8 100644 --- a/psycopg/connection_int.c +++ b/psycopg/connection_int.c @@ -280,6 +280,10 @@ conn_setup(connectionObject *self, PGconn *pgconn) pgres = psyco_exec_green(self, psyco_datestyle); } + if (self->server_version == 0 && self->protocol == 3) { /* vertica */ + self->encoding = strdup("UTF8"); + self->isolation_level = 0; + } else { if (pgres == NULL || PQresultStatus(pgres) != PGRES_COMMAND_OK ) { PyErr_SetString(OperationalError, "can't set datestyle to ISO"); IFCLEARPGRES(pgres); @@ -335,7 +339,7 @@ conn_setup(connectionObject *self, PGconn *pgconn) return -1; } self->isolation_level = conn_get_isolation_level(pgres); - + } Py_UNBLOCK_THREADS; pthread_mutex_unlock(&self->lock); Py_END_ALLOW_THREADS; diff --git a/psycopg/typecast_builtins.c b/psycopg/typecast_builtins.c index e8e5a1a..45b9dbc 100644 --- a/psycopg/typecast_builtins.c +++ b/psycopg/typecast_builtins.c @@ -1,15 +1,15 @@ static long int typecast_NUMBER_types[] = {20, 23, 21, 701, 700, 1700, 0}; -static long int typecast_LONGINTEGER_types[] = {20, 0}; +static long int typecast_LONGINTEGER_types[] = {6, 20, 0}; static long int typecast_INTEGER_types[] = {23, 21, 0}; -static long int typecast_FLOAT_types[] = {701, 700, 0}; -static long int typecast_DECIMAL_types[] = {1700, 0}; -static long int typecast_UNICODE_types[] = {19, 18, 25, 1042, 1043, 0}; +static long int typecast_FLOAT_types[] = {7, 701, 700, 0}; +static long int typecast_DECIMAL_types[] = {16, 1700, 0}; +static long int typecast_UNICODE_types[] = {8, 9, 19, 18, 25, 1042, 1043, 0}; static long int typecast_STRING_types[] = {19, 18, 25, 1042, 1043, 0}; -static long int typecast_BOOLEAN_types[] = {16, 0}; -static long int typecast_DATETIME_types[] = {1114, 1184, 704, 1186, 0}; -static long int typecast_TIME_types[] = {1083, 1266, 0}; -static long int typecast_DATE_types[] = {1082, 0}; -static long int typecast_INTERVAL_types[] = {704, 1186, 0}; +static long int typecast_BOOLEAN_types[] = {5, 0}; +static long int typecast_DATETIME_types[] = {12, 13, 1114, 1184, 704, 1186, 0}; +static long int typecast_TIME_types[] = {11, 15, 1083, 1266, 0}; +static long int typecast_DATE_types[] = {10, 1082, 0}; +static long int typecast_INTERVAL_types[] = {14, 704, 1186, 0}; static long int typecast_BINARY_types[] = {17, 0}; static long int typecast_ROWID_types[] = {26, 0}; static long int typecast_LONGINTEGERARRAY_types[] = {1016, 0}; </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload