problem with transaction
От | Guillermo Trutner |
---|---|
Тема | problem with transaction |
Дата | |
Msg-id | 00c301c276df$73524030$973c53a8@antarest08pf обсуждение исходный текст |
Ответы |
Re: problem with transaction
|
Список | 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 "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 DELETE -- Ahora las inserto nuevamente INSERT SELECT anio, codigo_con FROM d_coning_pipe WHERE anio = 2000 ; INSERT SELECT anio, codigo_con FROM d_recaud_pipe WHERE anio = 2000 ;
Lic. Guillermo Trutner
-o-~-o-*-o-~-o-*-o-~-o-
В списке pgsql-general по дате отправления: