search

nakagami / djfirebirdsql

Django Firebird database backend
BSD 3-Clause "New" or "Revised" License
10 stars 5 forks source link

Can´t migrate in Firebird3.0 #6

Open D1Alexandre opened 4 years ago

D1Alexandre commented 4 years ago

I get this error when migrating, how can I increase this size or something else to be done?

raise OperationalError(message, gds_codes, sql_code)

django.db.utils.OperationalError: ('Dynamic SQL Error\nSQL error code = -104\nNa me longer than database column size\n', -104)

nakagami commented 4 years ago

Can you tell me what changes you've made to the model? Please upload the migration file if you can!

mariuz commented 3 years ago

Seems to be an Firebird engine implementation issue , could you test with Firebird 4.0 ?

https://stackoverflow.com/questions/20155517/is-it-possible-to-extend-firebird-table-name-length

nakagami commented 3 years ago

Object name maxlenght matches the value of firebird4 https://github.com/nakagami/djfirebirdsql/blob/master/djfirebirdsql/operations.py#L305

mariuz commented 3 years ago

In Firebird 3 maxlenght is 31

nakagami commented 3 years ago

I see, I understand. I don't want to support many versions of Firebird, but Firebird 3.0 will still be used in the future, so I'll think about it.