| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | SZŰCS Gábor <surrano(at)mailbox(dot)hu>, pgsql-general(at)postgresql(dot)org, Rod Taylor <rbt(at)rbt(dot)ca> |
| Subject: | Re: adddepend and partial indexes |
| Date: | 2003-06-17 15:30:46 |
| Message-ID: | 13024.1055863846@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> AFAIK there's no such thing as a partial unique constraint so the index
> should probably just be left alone.
Yeah, that seems like a bug in adddepend --- it shouldn't try to
transform *all* unique indexes into unique constraints, only those
that can be expressed in the constraint syntax. So, no partial
indexes, no functional indexes, no non-btree indexes, and no
non-default opclasses. Rod, do you have time to fix that?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Mascari | 2003-06-17 15:32:31 | Re: Request for advice: Table design |
| Previous Message | Stephan Szabo | 2003-06-17 15:27:33 | Re: adddepend and partial indexes |