Re: Package version in PG_VERSION and version()

On 12/15/17 06:53, Christoph Berg wrote:
>> Why reinventing the wheel when there is already --with-extra-version
>> that you can use for the same purpose?
> That modifies the PG version number as such, as what psql is showing
> on connect. I'd think that is too intrusive.
>
> And it doesn't work anyway: $ ./configure --with-extra-version ' (Debian 10.1-2)'
> configure: WARNING: you should use --build, --host, --target
> configure: WARNING: invalid host type: (Debian 10.1-2)
> configure: error: argument required for --with-extra-version option

I think --with-extra-version would do exactly the right thing for you:

./configure --with-extra-version=' (FooNix 1.2.3)'
make
make install

$ psql --version
psql (PostgreSQL) 11devel (FooNix 1.2.3)

$ psql
psql (11devel (FooNix 1.2.3))
Type "help" for help.

=# select version();
PostgreSQL 11devel (FooNix 1.2.3) on ..., compiled by ...

=# show server_version;
11devel (FooNix 1.2.3)

=# show server_version_num;
110000

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services