Skip site navigation (1) Skip section navigation (2)

Error Message: ERROR: constraint "fk_FormaPago" does not exist

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 (view raw or flat)
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: pgAdmin II_1384.Log
Description: application/octet-stream (20.8 KB)

pgadmin-support by date

Next:From: Raphaƫl EnriciDate: 2003-11-26 17:41:40
Subject: Re: pgAdmin3 solaris
Previous:From: OlegDate: 2003-11-26 12:54:37
Subject: convert MSAccess to PostgreSQL 7.3.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group