public inbox for [email protected]  

help / color / mirror / Atom feed

From: Daniel Verite <[email protected]>
To: Paul Foerster <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: Pgsql-General List <[email protected]>
Subject: Re: libc to libicu via pg_dump/pg_restore?
Date: Fri, 07 Feb 2025 14:29:05 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

	Paul Foerster wrote:

> >> pg_restore: error: could not execute query: ERROR:  insert or update on table "table_1" violates foreign key constraint "..._fk"
> >> DETAIL:  Key (dokument_id)=(1000033680) is not present in table "...".
> > 
> > Is dokument_id an integer field?
> 
> Yes, it's a bigint.

It's hard to imagine that the change of collation is related to the
failure to create that constraint.

When a value is present in the target table but the FK check does not
find it, often the cause is index corruption.
But if you've just imported that dump, the index on the target column
should be brand new.
Still, you may check it with pg_amcheck [1] or try rebuilding it
just in case.


[1] https://www.postgresql.org/docs/current/app-pgamcheck.html

Best regards,
-- 
Daniel Vérité 
https://postgresql.verite.pro/

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: libc to libicu via pg_dump/pg_restore?
  In-Reply-To: <[email protected]>

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

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