Received: from txino.mikasa.eh (96-ZARA-X22.libre.retevision.es [62.82.245.96]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5MGJka63095 for ; Fri, 22 Jun 2001 12:19:46 -0400 (EDT) (envelope-from txinete@wanadoo.es) Received: from txino.mikasa.eh (localhost.localdomain [127.0.0.1]) by txino.mikasa.eh (Postfix) with SMTP id EFE066553B for ; Fri, 22 Jun 2001 17:10:39 -0400 (EDT) Content-Type: text/plain; charset="iso-8859-1" From: "J.Fernando Moyano" Organization: SymeX To: pgsql-sql@postgresql.org Subject: cache lookup failed ???? What is it ???!!! Date: Fri, 22 Jun 2001 17:10:39 -0400 X-Mailer: KMail [version 1.2] MIME-Version: 1.0 Message-Id: <01062217103904.27627@txino.mikasa.eh> Content-Transfer-Encoding: 8bit X-Archive-Number: 200106/376 X-Sequence-Number: 3668 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I can't execute this SQL query: DELETE FROM piezas WHERE ord_mec = '01-001' I get: ERROR: fmgr_info: function 39816: cache lookup failed Can someone help me with this error ?? ****************************************************** CREATE TABLE piezas ( n_pieza INTEGER PRIMARY KEY, n_material INTEGER NOT NULL, ord_mec VARCHAR(8) NOT NULL, t_inicio TIMESTAMP DEFAULT 'invalid', t_final TIMESTAMP DEFAULT 'invalid', ref_eisenor VARCHAR(32), ref_cliente VARCHAR(32), n_plano VARCHAR(32), n_lote VARCHAR(8), observaciones VARCHAR(256), FOREIGN KEY (n_material) REFERENCES materia_prima(n_material), FOREIGN KEY (ord_mec) REFERENCES ord_mecanizado(ord_mec) ); CREATE TABLE materia_prima ( n_material INTEGER PRIMARY KEY, fecha DATE NOT NULL DEFAULT 'today', n_albaran INTEGER, n_pedido_mp INTEGER, n_lote VARCHAR(8), cantidad INTEGER, usadas INTEGER DEFAULT '0' CHECK (usadas>=0 AND usadas<=cantidad), torcidas_plano INTEGER DEFAULT '0' CHECK (torcidas_plano>=0 AND torcidas_plano<=cantidad), torcidas_canto INTEGER DEFAULT '0' CHECK (torcidas_canto>=0 AND torcidas_canto<=cantidad), dim_ancho FLOAT, dim_alto FLOAT, dim_largo FLOAT, material VARCHAR(32), pc_C FLOAT, observaciones VARCHAR(256) ); CREATE FUNCTION materia_prima_release_one() RETURNS OPAQUE AS ' BEGIN UPDATE materia_prima SET usadas=usadas-1 WHERE n_material = OLD.n_material; RETURN OLD; END;' LANGUAGE 'plpgsql'; CREATE TRIGGER piezas_delete AFTER DELETE ON piezas FOR EACH ROW EXECUTE PROCEDURE materia_prima_release_one(); - -- Fernando Moyano Frase del día: - -------------- Si las mujeres fueran buenas, Dios tendria una. (*) SymeX ==> http://symex.lantik.com (*) WDBIL ==> http://wdbil.sourceforge.net (*) Informate sobre LINUX en http://www.linux.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.4 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7M7RPoZaf9MvtDvcRApqgAJ9tQjdcd6ACuvWMDrFXR2erAIlfOQCgoyBk TJhAno7UmoZfD/CUxvnMLpM= =HDIQ -----END PGP SIGNATURE-----