[postgis-devel] Function Removal

Regina Obe lr at pcorp.us
Wed Dec 16 12:10:53 PST 2020


>   postgis=# select st_asewkt(ST_MakePoint(1.2, 2.33));
>   ERROR:  function st_makepoint(double precision, double precision) is not
> unique
>   HINT:  Could not choose a best candidate function. You might need to add
> explicit type casts.
> 
> Yeah, it could be either my new one or the two-parameter form of the old
> one.
> 
> The obvious fix would be to remove the old signatures at the same time as
> adding the new one, but as I recall this leads to upgrade issues? This is
where
> my memory is failing. I know (a) a single signature with defaults and
> argument names is nicer and cleaner and also (b) every time I've done it
> there's been some kind of an outcry / mess.
> 
> Any help, thoughts?
> 
> P

This is for 3.2 (master) right, you aren't attempting this after we called
RC1 right?
The solution (though it may have changed with strk's voodoo) is, you add the
drop statement in

postgis_before_upgrade.sql







More information about the postgis-devel mailing list