pygresql and primary key

Gerhard Häring gerhard.haering at opus-gmbh.net
Thu Oct 10 11:28:39 CEST 2002


Marcin Kadziolka <marcin at linkor.com.pl> [2002-10-10 08:48 GMT]:
> Hi!
> 
> I'm using a pg module wrapper from pygresql.

Ouch. I'd recommend you use a DB-API module like pyPgSQL or psycopg. PyGreSQL
has a DB-API module called pgdb, too.

> I cannot use a get() method for tables containing primary keys definied for
> more than one field. It seems get() assumes primary key always consists of
> exactly one field.

Yes.

> How can I force it to use multiple column primary key?

You can't without changing the source in pg.py. Why not just use SQL and a
DB-API module?

-- Gerhard



More information about the Python-list mailing list