pgloader icon indicating copy to clipboard operation
pgloader copied to clipboard

Only select dependencies in the pg_class catalog

Open MikeN123 opened this issue 4 years ago • 1 comments

This makes sure we do not select dependencies form the pg_operator class or other similar things. Otherwise, if your FK has a dependency on something like a pg_operator (e.g., when your FK is pointing to a CITEXT column), things will break with the message:

ERROR pgsql: The value
         NIL
       is not of type
         PGLOADER.CATALOG:INDEX

during PGLOADER.PGSQL:LIST-ALL-FKEYS.

I'm not an expert on the exact contents on the pg_class and pg_depend tables, so can't guarantee this is the 100% correct fix.

Fixes dimitri/pgloader#1289

MikeN123 avatar Aug 20 '21 14:08 MikeN123

Hi I have same problem Help me please

pgloader version "3.6.10~devel" pgloader_debug.log

Xoer avatar Feb 04 '25 06:02 Xoer