Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

My model has a SlugField. When I try to save an instance of this model with the slug field set to a string which is longer than the field's max_length parameter (which is 50 by default), I get the following error from Postgresql: value too long for type character varying(50).

Is not Django (or Postgresql) supposed to truncate the string when saving? What can I do to fix it other than truncating it manually every time?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
1.9k views
Welcome To Ask or Share your Answers For Others

1 Answer

Either install south and resize the column (best option), or create a pre_save signal and add code to truncate the field to 50 characters before it is saved. Something like:

from django.db.models.signals import pre_save
from app.model import mymodel

def truncater(sender, instance, **kwargs):
    if sender is mymodel:
        if len(instance.fieldname)>50:
            instance.fieldname = instance.fieldname[:50]
pre_save.connect(truncater, sender=mymodel)

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...