unicode objects

This one won't work very well:

cur.execute("select * from test_table where name=%s",u'test')

I suppose this is a bug.  (postgresql handles unicode, doesn't it?)