small bug in ADD CONSTRAINT

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: small bug in ADD CONSTRAINT
Date: 2004-03-11 00:38:19
Message-ID: c2ocdo$h0g$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-03-11 06:45:27 BUG #1098: Multiple ON INSERT rules not applied properly in the case of INSERT...SELECT
Previous Message Tom Lane 2004-03-10 23:10:39 Re: BUG #1096: pg_restore cannot restore large objects with other oid columns