What does `Select version()` show?
On Mon, Jan 14, 2019 at 11:46 AM Ahsan Hadi <ahsan.h...@enterprisedb.com> wrote:
>
> Select CASE WHEN split_part(s,'.',1)::integer > 9 THEN
> db1-# split_part(s,'.',1) || '0' ELSE split_part(s,'.', 1) ||
> db1-# split_part(s,'.', 2) END AS v
> db1-# FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s;
> v
> ---
>
> (1 row)
>
> On Mon, Jan 14, 2019 at 2:35 PM Raúl Marín Rodríguez <rmrodrig...@carto.com>
> wrote:
>>
>> Hi Ahsan,
>>
>> It seems there is some error with the version detection mechanism as
>> it's detecting PG11+.
>>
>> Can you please check what's the output of:
>> {{{
>> Select CASE WHEN split_part(s,'.',1)::integer > 9 THEN
>> split_part(s,'.',1) || '0' ELSE split_part(s,'.', 1) ||
>> split_part(s,'.', 2) END AS v
>> FROM substring(version(), 'PostgreSQL ([0-9\.]+)') AS s;
>> }}}
>>
>> --
>> Raúl Marín Rodríguez
>> carto.com
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users@lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>
> --
> Ahsan Hadi
> Snr Director Product Development
> EnterpriseDB Corporation
> The Enterprise Postgres Company
>
> Phone: +92-51-8358874
> Mobile: +92-333-5162114
>
> Website: www.enterprisedb.com
> EnterpriseDB Blog: http://blogs.enterprisedb.com/
> Follow us on Twitter: http://www.twitter.com/enterprisedb
>
> This e-mail message (and any attachment) is intended for the use of the
> individual or entity to whom it is addressed. This message contains
> information from EnterpriseDB Corporation that may be privileged,
> confidential, or exempt from disclosure under applicable law. If you are not
> the intended recipient or authorized to receive this for the intended
> recipient, any use, dissemination, distribution, retention, archiving, or
> copying of this communication is strictly prohibited. If you have received
> this e-mail in error, please notify the sender immediately by reply e-mail
> and delete this message.
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
--
Raúl Marín Rodríguez
carto.com
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
