I wanted to bring up this bug: https://code.djangoproject.com/ticket/17763
as it's bitten me on a couple of projects recently
Summarizing the ticket:
==============
Django automatically generates a name that is longer than what the default
field length can hold.
INSERT INTO "auth_permission" ("name", "content_type_id", "codename")
VALUES (%s, %s, %s) (u'Can add study plan practice assessment tutorial
question', 52, u'add_studyplanpracticeassessmenttutorialquestion')
This will fail with a error about it not being able to fit in a varchar(50)
Table "public.auth_permission"
Column | Type | Modifiers
-----------------+------------------------+--------------------------------------------------------------
id | integer | not null default
nextval('auth_permission_id_seq'::regclass)
name | character varying(50 ) | not null
content_type_id | integer | not null
codename | character varying(100) | not null
This was under PostgreSQL and after modifying the field to have a length of
200, I was able to perform the insert.
==============
This is easy to run into, especially when other developers who might make a
particular model are working in SQLite3, where validation at the db level
does not happen and values are silently truncated. It can also happen
pretty easily when working with legacy database tables with overly verbose
table names.
The 50/100 char length constraint on name and codename seem to be rather
arbitrary to me. I think it seems reasonable to bump these up to 200 or
255, and provide validation on the lengths to be entered when performing
syncdb.
I'm happy to work on a patch/tests if there is interest. For now, when a
slightly longer class name is needed, the only real way around it is to
alter the model & the db, which is not ideal.
Thanks in advance!
-greg
--
You received this message because you are subscribed to the Google Groups
"Django developers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/django-developers/-/yEXJxLQj_V0J.
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/django-developers?hl=en.
