From: | "Lukas" <lukas(at)fmf(dot)vtu(dot)lt> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | 2 problems |
Date: | 2007-11-15 17:31:05 |
Message-ID: | 42439.217.117.29.29.1195147865.squirrel@fmf.vtu.lt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I am running PostgreSQL 8.1.0 on Gentoo Linux, DB is replicated with Slon
version 1.2.0.
Fist problem started with one node, with stopped to replicate with such
error:
2007-11-15 13:17:21 EET ERROR remoteWorkerThread_1: "insert into
"public"."kainos"
(paslaugos,laikai,abonimentas,kaina,pastaba,rodyti,tipas,vienkartinis,gal
ioja_nuo,galioja_iki,id,pradine_imoka,intervalas,intervalas_paskutinis,imoku_skaicius,viso_sumoketi,periodine_imoka,max_pirkiniu_suma,padalinys,padaliniu_gru
pe) values ('baseinas+treniruokliai ','Visos dienos
','1 m<EB>nesio ','284.00','Bendra korta
','t','V
isi','f',NULL,NULL,'1110',NULL,NULL,NULL,NULL,NULL,NULL,'50.00','0','201');
" ERROR: insert or update on table "kainos" violates foreign key
constraint "fk_kainos_padaliniu_grupe"
DETAIL: Key (padaliniu_grupe)=(201) is not present in table
"padaliniu_grupes".
Note that table "kainos" and table "padaliniu_grupes" are replicated!
only in two different sets.
Then I wanted to drop FK constraint "fk_kainos_padaliniu_grupe" to let
replication goon, and then create it back, but I got error:
ERROR: "padaliniu_grupes_pkey" is an index
SQL state: 42809
(SQL was ALTER TABLE kainos DROP CONSTRAINT fk_kainos_padaliniu_grupe;)
Why?
"padaliniu_grupes_pkey" is not an index!! and I do not want to drop it...
"padaliniu_grupes_pkey" is a PK on table "padaliniu_grupes":
ALTER TABLE padaliniu_grupes ADD CONSTRAINT padaliniu_grupes_pkey PRIMARY
KEY(pg_id);
Can anyone help us?
thx
Lukas
--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-11-15 17:48:00 | Re: 2 problems |
Previous Message | Alvaro Herrera | 2007-11-15 17:27:07 | Re: [GENERAL] "global/pg_control": Permission denied |