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

Started by Nonameabout 10 years ago1 messagesbugs
Jump to latest
#1Noname
postgres@jddonat.com

The following bug has been logged on the website:

Bug reference: 14372
Logged by: john donat
Email address: postgres@jddonat.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.

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs