BUG #14372: ll_to_earth(...) assumes it'll always be executed with 'public' in the search_path

From: postgres(at)jddonat(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14372: ll_to_earth(...) assumes it'll always be executed with 'public' in the search_path
Date: 2016-10-15 00:14:24
Message-ID: 20161015001424.1413.93990@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14372
Logged by: john donat
Email address: postgres(at)jddonat(dot)com
PostgreSQL version: 9.4.9
Operating system: Solaris 11.3
Description:

ll_to_earth(...) in the earthdistance extension assumes it'll always be
executed with 'public' in the search_path before any other definition of
earth().

This has the effect of bringing BDR 1.0.0 replication to a halt when using
ll_to_earth in replicated ddl, as in an indexed expression declaration.

this following code will halt bdr replication in it's tracks:
create extension if not exists cube;
create extension if not exists earthdistance;

create table zip_code_geo_poly_data (
id serial not null primary key,
zip_code text,
latitude numeric,
longitude numeric
);

CREATE INDEX zip_code_geo_poly_data_ll_to_earth
ON zip_code_geo_poly_data
USING gist(ll_to_earth(latitude, longitude));

see https://github.com/2ndQuadrant/bdr/issues/252 for more information.

Browse pgsql-bugs by date

  From Date Subject
Next Message kensuke.nakam 2016-10-15 03:38:32 BUG #14373: PostgreSQL Service is seems to be "Stopped" after Jan 19, 2038.
Previous Message kesavan.sengodan 2016-10-14 13:49:50 BUG #14371: Issue in uninstalling Postgres 8.4 in windows 10 OS