Skip to content

partial indexes #8985

@bordunosp

Description

@bordunosp

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions