PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16085
PG Version12.0
OSFedora 30
Opened2019-10-29 07:12:01+00
Reported byJulien Jerphanion
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16085
Logged by:          Julien Jerphanion
Email address:      (redacted)
PostgreSQL version: 12.0
Operating system:   Fedora 30
Description:        

Hello,

I add linking problem when when trying to compile a project that is relying
on libpq, namely [ttk](https://github.com/topology-tool-kit/ttk).

Here is a similar stack trace I got when compiling this project
```
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQfname@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQresStatus@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQftype@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQexec@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQfformat@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQclear@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQntuples@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQstatus@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQconnectdb@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQescapeStringConn@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQgetvalue@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQgetisnull@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQresultStatus@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQfinish@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQerrorMessage@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQnfields@RHPG_9.6'
/usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to
`PQresultErrorMessage@RHPG_9.6'
```

It seems that this was rather due to missing a library version within
`libpg`:
```bash
$ ldd /usr/lib64/vtk/libvtkIOPostgreSQL.so.1             
/usr/lib64/vtk/libvtkIOPostgreSQL.so.1: /usr/pgsql-12/lib/libpq.so.5: no
version information available (required by
/usr/lib64/vtk/libvtkIOPostgreSQL.so.1)
# ... 
	libpq.so.5 => /usr/pgsql-12/lib/libpq.so.5 (0x00007fa9b39c0000)
# ...
```

On my machine, this latter version was provided by several packages from
PostGreSQL 12, namely:
```bash
$ dnf provides /usr/pgsql-12/lib/libpq.so
postgresql12-devel-12rc1-2PGDG.f30.x86_64 : PostgreSQL development header
files and libraries
Repo        : pgdg12
Matched from:
Filename    : /usr/pgsql-12/lib/libpq.so

postgresql12-devel-12.0-1PGDG.f30.x86_64 : PostgreSQL development header
files and libraries
Repo        : @System
Matched from:
Filename    : /usr/pgsql-12/lib/libpq.so

postgresql12-devel-12.0-1PGDG.f30.x86_64 : PostgreSQL development header
files and libraries
Repo        : pgdg12
Matched from:
Filename    : /usr/pgsql-12/lib/libpq.so

# ...
``` 
I uninstalled them  and it resolves my problem:
```
$ sudo dnf erase postgresql12-devel-12.0-1PGDG.f30.x86_64
$ sudo dnf erase postgresql11-libs-11.5-1PGDG.f30.x86_64
$ sudo dnf erase postgresql12-libs-12.0-1PGDG.f30.x86_64
# ...
```

I think that this is correlated to the release of PostGreSQL 12.

Let me know if you need more information on this problem.

Best regards,
Julien Jerphanion (@jjerphan)

Messages

DateAuthorSubject
2019-10-29 07:12:01+00PG Bug reporting formBUG #16085: Potential missing version information available for /usr/pgsql-12/lib/libpq.so.5
2019-11-06 14:07:30+00Bruce MomjianRe: BUG #16085: Potential missing version information available for /usr/pgsql-12/lib/libpq.so.5
2019-11-06 15:12:14+00Devrim =?ISO-8859-1?Q?G=FCnd=FCz?=Re: BUG #16085: Potential missing version information available for /usr/pgsql-12/lib/libpq.so.5