Re: pguint Installation error in PostgreSQL server version 11.2 - Mailing list pgsql-admin

From Tom Lane
Subject Re: pguint Installation error in PostgreSQL server version 11.2
Date
Msg-id 16161.1563733420@sss.pgh.pa.us
Whole thread Raw
In response to pguint Installation error in PostgreSQL server version 11.2  (Suresh Seema <suresh.seema@opsveda.com>)
Responses Re: pguint Installation error in PostgreSQL server version 11.2  (Suresh Seema <suresh.seema@opsveda.com>)
List pgsql-admin
Suresh Seema <suresh.seema@opsveda.com> writes:
> I have installed PostgresSQL 11.2 version on Centos 7 and try to install
> *pguint* from source to install *TINYINT* datatype .
> ...
> *[postgres] # CREATE EXTENSION  uint;ERROR:  XX000: could not load library
> "/usr/pgsql-11/lib/uint.so": /usr/pgsql-11/lib/uint.so: undefined symbol:
> GET_1_BYTE

This is not a dependency problem.  GET_1_BYTE() was a macro defined in
PG10 and before, but it doesn't exist anymore as of PG11.  There are
two fairly plausible reasons why you might get this failure:

1. You built pguint against pre-v11 Postgres header files.

2. pguint actually contains a direct reference to GET_1_BYTE(), in
which case it's going to need some source-code fixes.

I don't know which applies.  But check your build process first.

            regards, tom lane



pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: How do I alter an existing column and add a foreign key which isa Primary key to a table?
Next
From: Evan Bauer
Date:
Subject: Re: install PostgreSQL using docker