Re: [HACKERS] patch: Distinguish between unique indexes and unique constraints

2010-04-18 Thread Josh Kupershmidt
On Sun, Apr 18, 2010 at 11:41 AM, Robert Haas wrote: > Josh - you may want to add your patch here: > > https://commitfest.postgresql.org/action/commitfest_view/open Added, thanks! Josh -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: h

Re: [HACKERS] patch: Distinguish between unique indexes and unique constraints

2010-04-18 Thread Robert Haas
On Sun, Apr 18, 2010 at 11:23 AM, Tom Lane wrote: > Robert Haas writes: >> You know, I've never really understood the difference between these >> two types of things, or why we need to support both.  Which may be >> just because I'm slow? > > Unique constraints are defined by the SQL standard, an

Re: [HACKERS] patch: Distinguish between unique indexes and unique constraints

2010-04-18 Thread Tom Lane
Robert Haas writes: > You know, I've never really understood the difference between these > two types of things, or why we need to support both. Which may be > just because I'm slow? Unique constraints are defined by the SQL standard, and have a syntax that can't support a lot of the extensions

Re: [HACKERS] patch: Distinguish between unique indexes and unique constraints

2010-04-18 Thread Robert Haas
On Sat, Apr 17, 2010 at 11:53 PM, Josh Kupershmidt wrote: > 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.1271187...@sss.pgh.pa.us > > Attached is a simple patch which

[HACKERS] patch: Distinguish between unique indexes and unique constraints

2010-04-17 Thread Josh Kupershmidt
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.1271187...@sss.pgh.pa.us Attached is a simple patch which clarifies unique constraints with "UNIQUE CONSTRAINT" in psql's \d+