| From: | William Diaz Pabón <widipa(at)hotmail(dot)com> |
|---|---|
| To: | <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Modificar el nombre de la constaint de una primary key |
| Date: | 2008-04-04 15:11:34 |
| Message-ID: | BAY139-W3890C394213EE1ACBE54C1CDF60@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Hola a todos.
Tengo una tabla asi:
CREATE TABLE curso_area( curso_sede numeric(30) NOT NULL, area character varying(4) NOT NULL, CONSTRAINT "Key1" PRIMARY KEY (curso_sede, area), CONSTRAINT curso_area_area_fk FOREIGN KEY (area) REFERENCES area (codigo) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT curso_area_curso_sede_fk FOREIGN KEY (curso_sede) REFERENCES curso_sede (consecutivo) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION)WITH (OIDS=FALSE);ALTER TABLE curso_area OWNER TO colegio;
pero quiero cambiar el nombre de la constraint "Key1", por le nombre curso_area_pk. Como puedo hacerlo si ya existen relaciones de esa tabla con otras?
Cordialmente. William Diaz Pabón Ing. de SistemasSoluciones Empresariales.Cel: 3173314172 - 3156396316Tunja - Boyacá - Colombia
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gilberto Castillo Martínez | 2008-04-04 15:46:39 | Re: Usuarios dinamicos |
| Previous Message | Sonia Perez Peña | 2008-04-04 14:58:03 | RV: instalacion del PHPPGADMIN |