I've reproduced an error on my system that occurs with 0.2.8 and 0.3.0,
but not 0.2.6. Test case is attached.
I'm using
Postgresql 7.4
Python 2.4
Pyscopg2 2.0.5.1
When inserting a new record for a table with a serial column, I get this
error:
sqlalchemy.exceptions.SQLError: (ProgrammingError) relation
"randall.things_id_seq" does not exist
'select nextval(\'"randall.things_id_seq"\')' {}
The error does not occur with SA 0.2.6.
Randall
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
from sqlalchemy import *
cns = "postgres://[EMAIL PROTECTED]/test"
schema='randall'
metadata = DynamicMetaData(name='web_metadata')
things = Table("things", metadata,
Column("id", Integer, primary_key=True),
Column("name", String(50)),
schema=schema
)
class Thing(object):
pass
Thing.mapper = mapper(Thing, things)
engine = create_engine(cns)
metadata.connect(engine)
metadata.create_all()
sess = create_session(engine)
thing = Thing()
thing.name = 'grimlen'
sess.save(thing)
sess.flush()
