Re: Rename or Re-Create Constraints?

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>
Subject: Re: Rename or Re-Create Constraints?
Date: 2011-04-09 22:30:17
Message-ID: 201104091530.18037.adrian.klaver@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday, April 09, 2011 2:59:06 pm Carlos Mennens wrote:
>
>
> Is there a difference between an INDEX and a CONSTRAINT?

Oops forgot to add this to my previous reply.

The short version, an INDEX is one form of a CONSTRAINT. For the long version
look at the CREATE TABLE section of the docs. It shows the various CONSTRAINTS
available for both columns and tables i.e NOT NULL, FOREIGN KEY, etc

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gordon Shannon 2011-04-10 00:41:44 Re: could not access status of transaction 1118722281
Previous Message Adrian Klaver 2011-04-09 22:21:46 Re: Rename or Re-Create Constraints?