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 schmi...@gmail.com 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

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

2010-04-18 Thread Tom Lane
Robert Haas robertmh...@gmail.com 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

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 t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com 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

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 robertmh...@gmail.com 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

[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+