Postgres Pro
Downloads
Home   >   mailing lists

small bug in ADD CONSTRAINT - Mailing list pgsql-bugs

From Joseph Shraibman
Subject small bug in ADD CONSTRAINT
Date
Msg-id c2ocdo$h0g$1@news.hub.org
Whole thread Raw
Responses Re: small bug in ADD CONSTRAINT  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: small bug in ADD CONSTRAINT  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
This works:

  ALTER TABLE segment ADD CONSTRAINT  name  unique(textfield, reseller);

This doesn't:
  ALTER TABLE segment ADD CONSTRAINT  name  unique(lower(textfield),
reseller);


I had to create a unique index.

pgsql-bugs by date:

Previous
From: Christopher Browne
Date:
Subject: Re: buglet in 7.1.4
Next
From: Christopher Browne
Date:
Subject: Re: buglet in 7.1.4