From: Tom Lane <tgl@sss.pgh.pa.us>
To: Suresh Seema <suresh.seema@opsveda.com>
cc: pgsql-admin@postgresql.org
Subject: Re: pguint Installation error in PostgreSQL server version 11.2
In-reply-to: 
 <CAJWZN5FtJ1t2TQay2_HqU_0j2sMBnTQG0my7aqthdxHM74hR9g@mail.gmail.com>
References: 
 <CAJWZN5FtJ1t2TQay2_HqU_0j2sMBnTQG0my7aqthdxHM74hR9g@mail.gmail.com>
Comments: In-reply-to Suresh Seema <suresh.seema@opsveda.com>
	message dated "Fri, 19 Jul 2019 11:31:45 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <16160.1563733420.1@sss.pgh.pa.us>
Date: Sun, 21 Jul 2019 14:23:40 -0400
Message-ID: <16161.1563733420@sss.pgh.pa.us>
Precedence: bulk

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