problem with transaction - Mailing list pgsql-general

CREATE TABLE "d_coning" (

"anio" int4 NOT NULL,

"codigo_con" int4 NOT NULL,

CONSTRAINT "d_coning_pkey" PRIMARY KEY ("anio", "codigo_con")

) WITH OIDS;

-- Table: d_recaud

CREATE TABLE "d_recaud" (

"anio" int4 NOT NULL,

"codigo_con" int4 NOT NULL,

CONSTRAINT "d_recaud_pkey" PRIMARY KEY ("anio"),

CONSTRAINT "<unnamed>" FOREIGN KEY ("anio", "codigo_con") REFERENCES "d_coning" ("anio", "codigo_con") ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE INITIALLY IMMEDIATE

) WITH OIDS;

When I put the follow into a transaction:

-- Primero borro las tablas correspondientes a año

DELETE FROM d_recaud WHERE anio = 2000;

DELETE FROM d_coning WHERE anio = 2000;

-- Ahora las inserto nuevamente

INSERT INTO d_coning (anio, codigo_con)

SELECT anio, codigo_con

FROM d_coning_pipe

WHERE anio = 2000

;

INSERT INTO d_recaud (anio, codigo_con)

SELECT anio, codigo_con

FROM d_recaud_pipe

WHERE anio = 2000 ;