Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group