Re: modify custom variables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: modify custom variables
Date
Msg-id 6787.1403281376@sss.pgh.pa.us
Whole thread Raw
In response to modify custom variables  (Vincent Mora <vincent.mora@oslandia.com>)
List pgsql-hackers
Vincent Mora <vincent.mora@oslandia.com> writes:
> If I understand the problem correctly, on upgrate (ALTER EXTENSION), the 
> old postgis library is already loaded, the old spatial functions are 
> replaced by new ones pointing to the new postgis library, a call to 
> DefineCustomStringVariable is made and:

>      ERROR:  attempt to redefine parameter "postgis.backend"

> I need to redefine the assign hook such that is calls the new library 
> backend and not the old one.

I think what you need to do is arrange the upgrade process so that the old
shared library doesn't get loaded in the same session as the new one.
Otherwise, you're likely to have lots more problems than just this.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Vincent Mora
Date:
Subject: modify custom variables
Next
From: Tom Lane
Date:
Subject: Shouldn't pg_(sh)seclabel.provider be marked NOT NULL?