On Tuesday, February 9, 2016 at 6:20:30 PM UTC-5, Michael Bayer wrote:
>
> I'm not seeing the word "preferred" in that document?It is actually
> simpler from a database introspection perspective to create a UNIQUE
> INDEX alone, the UNIQUE CONSTRAINT is redundant on the Postgresql
> platfo
On 02/09/2016 04:47 PM, Jonathan Beluch wrote:
Not sure about other DBs, but according to pg docs [1], it's preferred
to make a unique constraint (and know that you get the index for free)
versus creating a unique index.
I'm not seeing the word "preferred" in that document?It is actually
Not sure about other DBs, but according to pg docs [1], it's preferred to
make a unique constraint (and know that you get the index for free) versus
creating a unique index.
Knowing this for pg, you can just do unique=True and get the constraint and
the index. I realize this is a very small im
