pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How can I quit this: "Unique " to my table? more info... 2+ messages / 2 participants [nested] [flat]
* How can I quit this: "Unique " to my table? more info... @ 2003-04-01 18:17 Luis Mix <ksql2002@yahoo.com.mx> 2003-04-01 18:33 ` Re: How can I quit this: "Unique " to my table? more info... Rod Taylor <rbt@rbt.ca> 0 siblings, 1 reply; 2+ messages in thread From: Luis Mix @ 2003-04-01 18:17 UTC (permalink / raw) To: pgsql-sql; +Cc: Achilleus Mantzios <achill@matrix.gatewaynet.com> 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@yahoo.com.mx ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How can I quit this: "Unique " to my table? more info... 2003-04-01 18:17 How can I quit this: "Unique " to my table? more info... Luis Mix <ksql2002@yahoo.com.mx> @ 2003-04-01 18:33 ` Rod Taylor <rbt@rbt.ca> 0 siblings, 0 replies; 2+ messages in thread From: Rod Taylor @ 2003-04-01 18:33 UTC (permalink / raw) To: Luis Mix <ksql2002@yahoo.com.mx>; +Cc: pgsql-sql@postgresql.org, Achilleus Mantzios <achill@matrix.gatewaynet.com> 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 Attachments: signature.asc (application/pgp-signature, 186B) download ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-04-01 18:33 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-04-01 18:17 How can I quit this: "Unique " to my table? more info... Luis Mix <ksql2002@yahoo.com.mx> 2003-04-01 18:33 ` Rod Taylor <rbt@rbt.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox