Composite primary key with nullable columns

[Paul Johnston]

Hi,

I have a situation where I'm trying to us a composite primary key, where one of the columns can be null.

However, when I try to update an object I get the following error:

sqlalchemy.orm.exc.FlushError: Can't update table test using NULL for primary key value on column test.id2

Sample code here: http://dpaste.com/3Q8T09T

Is this something SQLAlchemy can do? From some quick tests, it seems SQLite can do it, not sure about other databases.

Paul

[Matt Zagrabelny]

NULL columns can't be primary keys in Pg - not sure if it is an ANSI
SQL standard.

-m