| From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: WHERE condition lost from conditional unique index |
| Date: | 2014-06-06 18:56:26 |
| Message-ID: | 1402080986366-5806365.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
jake fagan wrote
> Why would the migration work on my development but not on Jenkins?
The only obvious problem I can come up with is that your development
environment and the source for Jenkins do not have the same codebase.
Did you ever attempt to create this particular index without the where
clause - and now just recently converted it into a partial?
I doubt that Jenkins is silently ignoring the WHERE clause...an incorrect
source file is more likely.
> Am I applying the unique index correctly to begin with?
Yes, though it is a "partial unique index" since you are using a where
clause.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/WHERE-condition-lost-from-conditional-unique-index-tp5806355p5806365.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shubhra Sharma | 2014-06-11 16:08:33 | Need help. Getting an error in my function when I do a select * from foo_bar() |
| Previous Message | jake fagan | 2014-06-06 16:38:45 | WHERE condition lost from conditional unique index |