| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ian Barwick <barwick(at)gmx(dot)net> |
| Cc: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, Luis Mix <ksql2002(at)yahoo(dot)com(dot)mx>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: How can I quit this: "Unique " to my table? |
| Date: | 2003-04-01 16:12:42 |
| Message-ID: | 1267.1049213562@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Ian Barwick <barwick(at)gmx(dot)net> writes:
> On Tuesday 01 April 2003 21:26, Achilleus Mantzios wrote:
>> drop index b_prestamo_no_inventa_idx;
> ALTER TABLE b_prestamo DROP CONSTRAINT b_prestamo_no_inventa_key ??
The correct answer is "one or the other depending on which PG version
he's running" ;-). Before 7.3, drop the index; as of 7.3 you're
supposed to drop the constraint instead. (No harm in trying the wrong
one, it just won't let you do it.)
Looking at the output of psql's "\d b_prestamo" would be a good idea to
verify the spelling of the index and/or constraint name.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | V. Cekvenich | 2003-04-01 16:59:24 | unsubscribe |
| Previous Message | Jeff Hoffmann | 2003-04-01 15:53:16 | Re: Off topic : world database |