col_is_unique failing

21 views
Skip to first unread message

said

unread,
Jun 17, 2021, 2:29:44 PM6/17/21
to pgTAP Users
Hi,

A unique constraint is set on (KEYA, KEYB) with:

ALTER TABLE table ADD CONSTRAINT NAME UNIQUE (KEYA, KEYB).

I am trying to use:

SELECT col_is_unique(table, ARRAY[KEYA, KEYB])

but keep failing with the following error:

Index NAME should be unique.

I did make sure the constraint was set properly and check with psql (\d). Using PG 11

Any idea ?
Thanks

said

unread,
Jun 17, 2021, 2:41:20 PM6/17/21
to pgTAP Users
Please disregard this issue. It was a similar issue that was failing...

Sorry for the inconvenience.
Reply all
Reply to author
Forward
0 new messages