Hi there,
after Upgrading sqlalchemy to V 0.7.x i get the following error
Traceback (innermost last):
Module ZPublisher.Publish, line 126, in publish
Module ZPublisher.mapply, line 77, in mapply
Module ZPublisher.Publish, line 46, in call_object
Module <wrapper>, line 5, in wrapper
Module kss.core.actionwrapper, line 236, in apply
Module ruagaero.intradevcontent.browser.kontaktperson, line 178, in
kundenListSaveKontaktperson
Module ruagaero.intradevcontent.browser.kontaktperson, line 105, in getFlags
Module ruagaero.intradevcontent.content.flag, line 53, in findFlags
Module sqlalchemy.orm.query, line 1729, in all
Module sqlalchemy.orm.query, line 1838, in __iter__
Module sqlalchemy.orm.session, line 921, in _autoflush
Module sqlalchemy.orm.session, line 1493, in flush
Module sqlalchemy.orm.session, line 1566, in _flush
Module sqlalchemy.orm.unitofwork, line 343, in finalize_flush_changes
Module sqlalchemy.orm.session, line 1117, in _register_newly_persistent
FlushError: Instance <kontaktCL at 0xb2033cc> has a NULL identity key. If this
is an auto-generated value, check that the database table allows generation of
new primary key values, and that the mapped Column object is configured to
expect these generated values. Ensure also that this flush() is not occurring
at an inappropriate time, such as within a load() event.
kontaktCL has an "autoincrement" sequence defined as follows:
ALTER TABLE kontakt ALTER COLUMN konid SET DEFAULT
nextval(('kontakt_konid_seq'::text)::regclass);
up to now this sequence was somehow managed by sqlalchemy.
The only thing I do create a new record is:
kontaktperson = kontaktpersonCL()
for k,v in values.items():
setattr(kontaktperson, k, v)
session.add(kontaktperson)
session.commit()
on my development box this works well (postgres 8.4). However on the live
database (which is postgres 7.x) I get the error mentioned above.
Is there some flag I can set, so sa behaves as it did before?
thanks
robert
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
