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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc