Unique constraint and unique index - Mailing list pgsql-general

From Ivan Radovanovic
Subject Unique constraint and unique index
Date
Msg-id 5214FCDA.7080509@gmail.com
Whole thread Raw
Responses Re: Unique constraint and unique index  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Just to verify:
- when unique constraint is created using appropriate syntax rows are
added to tables pg_constraint and pg_index (pg_constraint with type 'u'
and referring to index with indisunique set to true)
- when unique index is created row is added only to pg_index table but
not to pg_constraint table (although in fact that index is behaving like
constraint on table)

Is that correct?

Regards,
Ivan


pgsql-general by date:

Previous
From: Robert Sosinski
Date:
Subject: Re: Memory Issue with array_agg?
Next
From: Joseph Marlin
Date:
Subject: WAL Replication Working but Not Working