Re: Unique indicies - Mailing list pgsql-general

From Dot Yet
Subject Re: Unique indicies
Date
Msg-id 93bc4af40802221333nc541d6dk87ee47254d649852@mail.gmail.com
Whole thread Raw
In response to Re: Unique indicies  (Erik Jones <erik@myemma.com>)
List pgsql-general
oops.... yeah... must have read it clearly
 
rgds,
dotyet

 
On 2/22/08, Erik Jones <erik@myemma.com> wrote:

On Feb 22, 2008, at 8:38 AM, Dot Yet wrote:

> that would mean
>
> Every row in foo for column f1 has to be unique
> and
> Every row in foo for column f2 has to be unique

The OP was asking about maintaining normal indexes on each in
addition to the unique index on (f1, f2), not separate unique indexes.

Erik Jones

DBA | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com




pgsql-general by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Understanding ps -ef "command" column
Next
From: "Kynn Jones"
Date:
Subject: PostgreSQL's hashing function?