Re: [GENERAL] Pg uses non-unique index instead of pkey index

[Tom Lane]

"Thalis A. Kalfigopoulos" <[EMAIL PROTECTED]> writes:
> Why exactly is experimentsc_expid_i chosen over experimentsc_pkey?

There is no reason to prefer either one over the other.  So you get
a quasi-random choice (whichever one the optimizer happens to consider
first, I think).

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])