Re: pguint Installation error in PostgreSQL server version 11.2

[Suresh Seema <suresh.seema@xxxxxxxxxxx>]

Hi Tom,

Thanks for your support, but i have installed PostgreSQL packages from RPM repo not from Source code. 

Please find RPM repo below. 

[pgdg11-source]
name=PostgreSQL 11 $releasever - $basearch - Source
failovermethod=priority
baseurl=https://download.postgresql.org/pub/repos/yum/srpms/11/redhat/rhel-$releasever-$basearch

Please suggest me on this.

Regards,

Suresh Seema

On Sun, Jul 21, 2019 at 11:53 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Suresh Seema <suresh.seema@xxxxxxxxxxx> 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

--

Regards,

Suresh Seema