Re: Unique and null

I'm using Postgresql 

does CharField unique solves problem of uniqueness ,

can we work with uuid model.

 

On Wed, Apr 7, 2021 at 6:51 PM Derek <gamesbook@gmail.com> wrote:

Are you using MySQL?

https://stackoverflow.com/questions/3712222/does-mysql-ignore-null-values-on-unique-constraints

On Wednesday, 7 April 2021 at 08:07:35 UTC+2 Mike Dewhirst wrote:

I have just made a CharField unique and Django detects duplicates nicely
but seems to ignore multiple instances where the field value is null.

    arn = models.CharField(
        max_length=MEDIUM,
        unique=True,
        null=True,
        blank=True,
    )

Is this correct behaviour?

Thanks

Mike



--
Signed email is an absolute defence against phishing. This email has
been signed with my private key. If you import my public key you can
automatically decrypt my signature and be sure it came from me. Just
ask and I'll send it to you. Your email software can handle signing.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/efd40f22-50d8-4250-9738-95d2152e68ecn%40googlegroups.com.

--

Best Regards,

Bikash Poudel

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAE0sOGzZbTGgvQoo3zHPc3GmDriCrzCDHKs6NUmxc1F21gG-cQ%40mail.gmail.com.