Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E24FB2E2368 for ; Thu, 15 Nov 2007 13:34:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 33784-07 for ; Thu, 15 Nov 2007 13:33:44 -0400 (AST) Received: from fmf.vtu.lt (fmf.vgtu.lt [193.219.145.206]) by postgresql.org (Postfix) with ESMTP id 82D472E2DCF for ; Thu, 15 Nov 2007 13:34:03 -0400 (AST) Received: from fmf.vtu.lt (localhost [127.0.0.1]) by fmf.vtu.lt (Postfix) with ESMTP id 3965F100AE for ; Thu, 15 Nov 2007 19:31:05 +0200 (EET) Received: from 217.117.29.29 (SquirrelMail authenticated user nso) by fmf.vtu.lt with HTTP; Thu, 15 Nov 2007 19:31:05 +0200 (EET) Message-ID: <42439.217.117.29.29.1195147865.squirrel@fmf.vtu.lt> Date: Thu, 15 Nov 2007 19:31:05 +0200 (EET) Subject: 2 problems From: "Lukas" To: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.8 MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-VGTU-MailScanner-OpenProtect-Information: Please contact the ISP for more information X-VGTU-MailScanner-OpenProtect: Found to be clean X-VGTU-MailScanner-OpenProtect-MCPCheck: X-VGTU-MailScanner-OpenProtect-From: lukas@fmf.vtu.lt X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL=0.001, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200711/155 X-Sequence-Number: 27398 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 mnesio ','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.