On Sunday 22 June 2008 20:54:25 Michael Bayer wrote:
> Both #820 and #571 are fixed in 0.4 and 0.5. I'm looking forward
> to seeing what else is wrong with long label names.
>
from sqlalchemy import *
from sqlalchemy.orm import *
import sys
metadata = MetaData( sys.argv[1:] and sys.argv[1] or 'sqlite://')
metadata.bind.echo = 'echo' in sys.argv
aa = 'itm'*30
#56 works on postgres
#57 and above - not
item_table = Table( aa[:57],
metadata,
Column('id', Integer, primary_key=True),
Column('name', String(50)))
class Item(object):
def __init__(self, name): self.name = name
def __str__(self): return self.name
item_mapper = mapper(Item, item_table, )
metadata.create_all()
session = create_session()
session.save(Item('aaa'))
session.save(Item('vvvv'))
session.flush()
items = session.query(Item)
for item in items: print item
---------------
results in:
sqlalchemy.exceptions.ProgrammingError: (ProgrammingError)
relation "itmitmitmitmitmitmitmitmitmitmitmitmitmitmitmitmitmitmitm_id_se"
does not exist
'select
nextval(\'"itmitmitmitmitmitmitmitmitmitmitmitmitmitmitmitmitmitmitm_id_seq"\')'
None
seems mangling should start for any len(name) > maxsize -
len("_id_seq")
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
