[sqlalchemy] PG error I don't understand.

2012-08-21 Thread Warwick Prince
Hi I have created a simple update like this on a PG database via PG8000; table=Table('invoice_line_items', meta, autoload=True) query = table.update() query = query.where(and_(eq(table.c.InvBook, 'SC'), eq(table.c.InvNum, 12862), eq(table.c.InvLine, 1))) query = query.values(**data)

Re: [sqlalchemy] PG error I don't understand.

2012-08-21 Thread Michael Bayer
On Aug 21, 2012, at 6:32 PM, Warwick Prince wrote: Hi I have created a simple update like this on a PG database via PG8000; table=Table('invoice_line_items', meta, autoload=True) query = table.update() query = query.where(and_(eq(table.c.InvBook, 'SC'), eq(table.c.InvNum, 12862),