[postgis-devel] Making PostGIS not schema relocateable to fix materialized view, restore issues, foreign table issues

Stephen Frost sfrost at snowman.net
Fri Apr 1 07:36:13 PDT 2016


* Stephen Woodbridge (woodbri at swoodbridge.com) wrote:
> On 4/1/2016 9:11 AM, Stephen Frost wrote:
> >Thoughts?
> 
> What happens if the user does something like:
> 
> alter extension set schema to blah;
> 
> on a dependent schema? Can you even do that?

The first part of Regina's proposal, which I agreed with, was to make
PostGIS not relocatable, which means that

alter extension postgis set schema xxx;

would return an error saying that the postgis extension is not
relocatable.

Thanks!

Stephen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20160401/80f24f57/attachment.sig>


More information about the postgis-devel mailing list