Skip site navigation (1) Skip section navigation (2)

2 problems

From: "Lukas" <lukas(at)fmf(dot)vtu(dot)lt>
To: pgsql-novice(at)postgresql(dot)org
Cc: slony1-general(at)lists(dot)slony(dot)info
Subject: 2 problems
Date: 2007-11-15 14:04:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

 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

2007-11-15 13:17:21 EET ERROR  remoteWorkerThread_1: "insert into
pe) values ('baseinas+treniruokliai                  ','Visos dienos  
','1 m<EB>nesio                               ','284.00','Bendra korta    
" 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

 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;)

 "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

 Can anyone help us?


This message has been scanned for viruses and
dangerous content by OpenProtect(, and is
believed to be clean.


pgsql-novice by date

Next:From: Carlos Muñoz RodríguezDate: 2007-11-15 15:35:30
Subject: Numeric type equivalent
Previous:From: Sean DavisDate: 2007-11-15 12:41:52
Subject: Building full-text index

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group