Re: pguint Installation error in PostgreSQL server version 11.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Suresh Seema <suresh(dot)seema(at)opsveda(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pguint Installation error in PostgreSQL server version 11.2
Date: 2019-07-21 18:23:40
Message-ID: 16161.1563733420@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Suresh Seema <suresh(dot)seema(at)opsveda(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Evan Bauer 2019-07-21 21:16:26 Re: install PostgreSQL using docker
Previous Message Scott Ribe 2019-07-21 17:30:52 Re: How do I alter an existing column and add a foreign key which is a Primary key to a table?