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

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 versionpostgres (PostgreSQL) 7.1.2
____________________

What happen some one can help me...?
Thank all...


-- 
Best regards,Luis                          mailto:ksql2002@yahoo.com.mx

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