PostgreSQL HSTORE field value updates do not mark object as dirty

[Priit Laes]

It seems that when changing value of the key in the HSTORE field, the object isn't marked dirty.

Simple testcase is here: https://gist.github.com/4277752

[Priit Laes]

sqla_hstore.py

[Mike Bayer]

try it like this:

from sqlalchemy.ext.mutable import MutableDict

class C(Base):
    __tablename__ = 'foo'

    id = Column(Integer, primary_key=True)
    hashes = Column(MutableDict.as_mutable(HSTORE), server_default=text("''::hstore"))

see the 4th paragraph/example at: http://docs.sqlalchemy.org/en/rel_0_8/dialects/postgresql.html?highlight=hstore#sqlalchemy.dialects.postgresql.HSTORE