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: [email protected]
Views: Whole Thread | Raw Message | 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/[email protected]

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