Re: How can I quit this: "Unique " to my table? more info...

On Tue, 2003-04-01 at 13:17, Luis Mix wrote:
> Hello pgsql-sql,
>
> I tried with both, but I obtain the follow Error.
>
> ____________________
> >> drop index b_prestamo_no_inventa_idx;
>
> ALTER TABLE b_prestamo drop index b_prestamo_no_inventa_idx;
>
> ERROR:  parser: parse error at or near "b_prestamo1_no_inventa_idx"

Drop the ALTER TABLE <table>

Just do:
DROP INDEX ...

> --------------------
>
> > ALTER TABLE b_prestamo DROP CONSTRAINT b_prestamo_no_inventa_key;

This is 7.3 syntax.


--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc