pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed2 problems
2+ messages / 2 participants
[nested] [flat]
* 2 problems
@ 2007-11-15 17:31 Lukas <lukas@fmf.vtu.lt>
0 siblings, 1 reply; 2+ messages in thread
From: Lukas @ 2007-11-15 17:31 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 2 problems
@ 2007-11-15 17:48 Tom Lane <tgl@sss.pgh.pa.us>
parent: Lukas <lukas@fmf.vtu.lt>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2007-11-15 17:48 UTC (permalink / raw)
To: Lukas <lukas@fmf.vtu.lt>; +Cc: pgsql-admin
"Lukas" <lukas@fmf.vtu.lt> writes:
> I am running PostgreSQL 8.1.0 on Gentoo Linux, DB is replicated with Slon
> version 1.2.0.
Why are you using a two-year-old database release on a bleeding-edge
operating system? Please at least get yourself onto some fairly recent
8.1.x minor release, before one of the bugs in 8.1.0 eats your data.
As far as your questions go, you seem to be running into Slony
restrictions, so the slony mailing lists are the place to get help.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-11-15 17:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-15 17:31 2 problems Lukas <lukas@fmf.vtu.lt>
2007-11-15 17:48 ` Tom Lane <tgl@sss.pgh.pa.us>
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