pg_bulkload icon indicating copy to clipboard operation
pg_bulkload copied to clipboard

Error on Ubuntu

Open pjfalbe opened this issue 2 years ago • 0 comments

When trying to register pg_bulkload on Ubuntu 22.10 I get this error. I download the zip of the source compiled and when running the follwoing code I get the error below. Any help would be appreciated. I

BEGIN;

CREATE SCHEMA pgbulkload;

CREATE FUNCTION pgbulkload.pg_bulkload( IN options text[], OUT skip bigint, OUT count bigint, OUT parse_errors bigint, OUT duplicate_new bigint, OUT duplicate_old bigint, OUT system_time float8, OUT user_time float8, OUT duration float8 ) AS '/usr/lib/postgresql/14/lib/pg_bulkload', 'pg_bulkload' LANGUAGE C VOLATILE STRICT;

COMMIT;

BEGIN CREATE SCHEMA psql:~/pg_bulkload-master/pg_bulkload.sql:23: ERROR: could not load library "/usr/lib/postgresql/14/lib/pg_bulkload.so": /usr/lib/postgresql/14/lib/pg_bulkload.so: undefined symbol: _bt_dedup_save_htid ROLLBACK itsadell:~/pg_bulkload-master$ psql --version psql (PostgreSQL) 14.6 (Ubuntu 14.6-0ubuntu0.22.10.1)

pjfalbe avatar Jan 30 '23 13:01 pjfalbe