Re: About pyvertica (a clone of pyscopg2)

From: Federico Di Gregorio <fog(at)initd(dot)org>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
Cc: Angel Freire <cuerty(at)gmail(dot)com>, psycopg(at)postgresql(dot)org
Subject: Re: About pyvertica (a clone of pyscopg2)
Date: 2011-09-07 09:52:23
Views: Raw Message | Whole Thread | Download mbox
Lists: psycopg

On 07/09/11 11:38, Daniele Varrazzo wrote:
> It may have been this:
> Looks like Vertica has a few differences in the types oid.
> Unfortunately there is at least a conflict: from the patch I see oid
> 16 is used by Vertica as a decimal type, while Postgres uses the same
> oid for the bool type. A solution could be to detect vertica at
> connection time (which seems done by checking server_version = 0, I
> don't know if there is a more robust way) and re-organize the
> typecaster map accordingly.

If that are the only changes needed we can probably reorganize the type
map into two different maps and attach the correct one at connection
time. Then psycopg would be able to work with Vertica and PostgreSQL at
the same time. Pretty useful to transfer data to and from. :)


Federico Di Gregorio fog(at)initd(dot)org
Nessuno dice che non si possa sognare in dettaglio, essere realistici
e magari realizzarlo pure, il sogno. -- <dani>

In response to

Browse psycopg by date

  From Date Subject
Next Message Marco Beri 2011-09-07 09:58:24 Re: About pyvertica (a clone of pyscopg2)
Previous Message Daniele Varrazzo 2011-09-07 09:38:52 Re: About pyvertica (a clone of pyscopg2)