From: | "Rizzo, Nicolas Leonardo" <nicolas(at)lanus(dot)tv> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Error Message: ERROR: constraint "fk_FormaPago" does not exist |
Date: | 2003-11-26 14:39:55 |
Message-ID: | 001c01c3b42b$28be4f20$1600a8c0@lanus.tv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
-- System Information --
Platform: Windows 2000
Version: 5.0
Build: 2195 Service Pack 4
-- Application Information --
Name: pgAdmin II
Version: 1.6.0
Descripton:
Name: pgSchema
Version: 1.6.0
Descripton: PostgreSQL Schema Objects v1.6.0
-- Database Information --
Version: 7.4.0
Descripton: PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC 2.95.4
-- Driver Information --
Name: PostgreSQL
Version: 7.3.115
Descripton: PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC 2.95.4
-- Error Information --
Description: ERROR: constraint "fk_FormaPago" does not exist
Number: -2147467259
Routine: pgAdmin II:frmTable.cmdOK_Click
************************************************************
Insert your comment:
Agrege una FK, y luego cuando la quiero borrar me muestra ese error...
por que la agrega '' '' al nombre ...?
Example:
BAD --> CONSTRAINT "fk_FormaPago" FOREIGN KEY (id_forma_pago) REFERENCES forma_de_pago (id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE
GOOD --> CONSTRAINT fk_FormaPago FOREIGN KEY (id_forma_pago) REFERENCES forma_de_pago (id) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE
Attachment | Content-Type | Size |
---|---|---|
pgAdmin II_1384.Log | application/octet-stream | 20.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Raphaël Enrici | 2003-11-26 17:41:40 | Re: pgAdmin3 solaris |
Previous Message | Oleg | 2003-11-26 12:54:37 | convert MSAccess to PostgreSQL 7.3.2 |