[GENERAL] Should I drop / create extensions after upgraging?
Hello all! I'm on Ubuntu 11.10, using 9.1.4. There was a new package for 9.1.5, and I just finished my upgrade. I make use of the uuid-ossp and tablefunc extensions. What is the expected upgrade procedure for these extensions? A drop followed by a create? Or is there something else less invasive? I can't find any references to upgrades on http://www.postgresql.org/docs/9.1/static/sql-createextension.html, nor on http://wiki.postgresql.org/wiki/ExtensionPackaging. Where should I have looked to find a reference to upgrading? Thanks! François Beausoleil -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Should I drop / create extensions after upgraging?
On 23 Srpen 2012, 18:19, François Beausoleil wrote: Hello all! I'm on Ubuntu 11.10, using 9.1.4. There was a new package for 9.1.5, and I just finished my upgrade. I make use of the uuid-ossp and tablefunc extensions. What is the expected upgrade procedure for these extensions? A drop followed by a create? Or is there something else less invasive? I can't find any references to upgrades on http://www.postgresql.org/docs/9.1/static/sql-createextension.html, nor on http://wiki.postgresql.org/wiki/ExtensionPackaging. Where should I have looked to find a reference to upgrading? The minor updates (e.g. from 9.1.4 to 9.1.5) are a drop-in binary replacements. You don't need to do anything special about the extensions, it just works (unless there's something really broken). Tomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Should I drop / create extensions after upgraging?
Tomas Vondra t...@fuzzy.cz writes: On 23 Srpen 2012, 18:19, François Beausoleil wrote: I'm on Ubuntu 11.10, using 9.1.4. There was a new package for 9.1.5, and I just finished my upgrade. I make use of the uuid-ossp and tablefunc extensions. What is the expected upgrade procedure for these extensions? A drop followed by a create? Or is there something else less invasive? The minor updates (e.g. from 9.1.4 to 9.1.5) are a drop-in binary replacements. You don't need to do anything special about the extensions, it just works (unless there's something really broken). Or perhaps more to the point: if there were something special you had to do, the release notes for 9.1.5 would have told you about it. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
