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"
--------------------
> ALTER TABLE b_prestamo DROP CONSTRAINT b_prestamo_no_inventa_key;
ERROR: parser: parse error at or near ";"
____________________
>The correct answer is "one or the other depending on which PG version
postgres (PostgreSQL) 7.1.2
____________________
What happen some one can help me...?
Thank all...
--
Best regards,
Luis mailto:ksql2002(at)yahoo(dot)com(dot)mx