pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Lukas <lukas@fmf.vtu.lt>
To: pgsql-admin@postgresql.org
Subject: 2 problems
Date: Thu, 15 Nov 2007 19:31:05 +0200 (EET)
Message-ID: <42439.217.117.29.29.1195147865.squirrel@fmf.vtu.lt> (raw)

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.




view thread (2+ messages)  latest in thread

Message-ID: <42439.217.117.29.29.1195147865.squirrel@fmf.vtu.lt>
Permalink:  ../42439.217.117.29.29.1195147865.squirrel@fmf.vtu.lt/
Also on:    postgresql.org/message-id/42439.217.117.29.29.1195147865.squirrel@fmf.vtu.lt

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: lukas@fmf.vtu.lt
  Subject: Re: 2 problems
  In-Reply-To: <42439.217.117.29.29.1195147865.squirrel@fmf.vtu.lt>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox