patch: Distinguish between unique indexes and unique constraints

From: Josh Kupershmidt <schmiddy(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: patch: Distinguish between unique indexes and unique constraints
Date: 2010-04-18 03:53:01
Message-ID: t2q4ec1cf761004172053jdd53782eo7e140a15a7890e7e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Addressing TODO item "Distinguish between unique indexes and unique
constraints in \d+" for psql, and picking up from thread:
http://archives.postgresql.org/message-id/8780.1271187360@sss.pgh.pa.us

Attached is a simple patch which clarifies unique constraints with
"UNIQUE CONSTRAINT" in psql's \d+ description of a table. The
appearance of unique indexes is left as-is.

== Old \d+ display ==
Indexes:
"name_uniq_constr" UNIQUE, btree (name)

== New \d+ display ==
Indexes:
"name_uniq_constr" UNIQUE CONSTRAINT, btree (name)

Josh

Attachment Content-Type Size
psql_constraints.patch application/octet-stream 1.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alex Hunsaker 2010-04-18 06:48:41 [PATCH] fix segfault with DO and plperl/plperlu
Previous Message Robert Haas 2010-04-18 03:23:28 enable_material patch