Thread: Re: Tab-completion error...?

On 12/22/21 2:14 PM, Theodore M Rolle, Jr. wrote:
Please reply to list also.
Ccing list.

 From below, what did pacman -Syyuu do?

> You are correct in guessing what I did...
>
> config.log:
> a bunch of
> #define HAVE_LIBREADLINE 1
> then
> configure:13450: checking readline/readline.h usability
> configure:13450: gcc -c -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Werror=vla -Wendif-labels
> -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type
> -Wformat-security -fno-strict-aliasing -fwrapv
> -fexcess-precision=standard -Wno-format-truncation
> -Wno-stringop-truncation -O2 -I/home/ted/hercules-helper/rexx/include
> -D_GNU_SOURCE  conftest.c >&5
> configure:13450: $? = 0
>
>     configure:13450: result: yes
>     configure:13450: checking readline/readline.h presence
>     configure:13450: gcc -E -I/home/ted/hercules-helper/rexx/include
>     -D_GNU_SOURCE  conftest.c
>     configure:13450: $? = 0
>     configure:13450: result: yes
>     configure:13450: checking for readline/readline.h
>     configure:13450: result: yes
>     configure:13480: checking readline/history.h usability
>     configure:13480: gcc -c -Wall -Wmissing-prototypes -Wpointer-arith
>     -Wdeclaration-after-statement -Werror=vla -Wendif-labels
>     -Wmissing-format-attribute -Wimplicit-fallthrough=3
>     -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv
>     -fexcess-precision=standard -Wno-format-truncation
>     -Wno-stringop-truncation -O2
>     -I/home/ted/hercules-helper/rexx/include -D_GNU_SOURCE  conftest.c >&5
>     configure:13480: $? = 0
>     configure:13480: result: yes
>     configure:13480: checking readline/history.h presence
>     configure:13480: gcc -E -I/home/ted/hercules-helper/rexx/include
>     -D_GNU_SOURCE  conftest.c
>     configure:13480: $? = 0
>     configure:13480: result: yes
>     configure:13480: checking for readline/history.h
>     configure:13480: result: yes
>     configure:13602: checking zlib.h usability
>     configure:13602: gcc -c -Wall -Wmissing-prototypes -Wpointer-arith
>     -Wdeclaration-after-statement -Werror=vla -Wendif-labels
>     -Wmissing-format-attribute -Wimplicit-fallthrough=3
>     -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv
>     -fexcess-precision=standard -Wno-format-truncation
>     -Wno-stringop-truncation -O2
>     -I/home/ted/hercules-helper/rexx/include -D_GNU_SOURCE  conftest.c >&5
>     configure:13602: $? = 0
>
> It looks good, doesn't it?
> N.B. v14.1 is the first version to have this problem. Another thought:
> perhaps the pacman -Syyuu  update did it.


--
Adrian Klaver
adrian.klaver@aklaver.com

"Theodore M Rolle, Jr." <stercor@gmail.com> writes:
> I don't use pacman for PostgreSQL.
> I compile from source.

The point is that your from-source build of psql might be linking
to an out-of-date copy of libpq.so provided by the OS.  Linux
machines tend to do that (i.e., prefer libraries in /usr/lib[64])
unless you mess with the dynamic loader's configuration.

Try "ldd /path/to/psql" and see what it says about which libpq
is getting used.

                        regards, tom lane

"Theodore M Rolle, Jr." <stercor@gmail.com> writes:
> ldd /usr/local/pgsql/bin/psql
> linux-vdso.so.1 (0x0000ffffa2bef000)
> libpq.so.5 => /USR/local/lib/libpq.so.5 (0x0000ffffa2aaf000)
> libreadline.so.8 => /usr/lib/libreadline.so.8 (0x0000ffffa2a1d000)
> libpthread.so.0 => /usr/lib/libpthread.so.0 (0x0000ffffa29ed000)
> libm.so.6 => /usr/lib/libm.so.6 (0x0000ffffa2941000)
> libc.so.6 => /usr/lib/libc.so.6 (0x0000ffffa27cd000)
> /lib/ld-linux-aarch64.so.1 => /usr/lib/ld-linux-aarch64.so.1
> (0x0000ffffa2bbe000)
> libncursesw.so.6 => /usr/lib/libncursesw.so.6 (0x0000ffffa2748000

Hm, is /USR actually in caps, or did you change that for emphasis?

> I'm at a loss as to where the /USR came from.
> It's not in config.log (compile time)
> nor in the psql executable (run time).

I think it came out of /etc/ld.so.conf.

BTW, by default PG would link psql using an rpath switch pointing at
/usr/local/pgsql/lib, which I assume is where your manual build
put its libpq.so.  That's evidently not having success getting that
libpq.so to be used.  Did you tell configure to --disable-rpath?
Or maybe move the installation after building it?

                        regards, tom lane