partial indexes #8986

Unanswered

bordunosp asked this question in Support Questions

bordunosp
Sep 6, 2021

postgresql
server_version: '13'

/**
* @ORM\Table(
 *     name="tbl_name",
 *     uniqueConstraints={
 *       @ORM\UniqueConstraint(
 *         name="api_key__uidx",
 *         columns={"api_key"},
 *         options={"WHERE": "((api_key)::text <> ''::text)"}
 *       )
 *     }
 * )
 */

doctrine:migrations:diff

DROP INDEX api_key__uidx
CREATE UNIQUE INDEX api_key__uidx ON tbl_name (api_key)

Any tips to support partial indexes?

Replies: 0 comments

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment