On Mon, Jul 1, 2013 at 8:09 AM, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > Joe Conway escribió: > >> Actually, given that this change will create version 1.1 of the >> extension, I believe the 1.0 versions of the sql scripts should >> probably be removed entirely. Can someone with more knowledge of the >> extension facility comment on that? > > Besides what Michael said, another thing is that you need to ensure that > if the functions are run with the 1.0 definitions, they don't crash > (i.e. you need to check the number of arguments actually passed to > function(s), and ensure no changes are made to the types of previously > existing arguments). You can test this by installing the 1.0 version in > a 9.3 database, then pg_upgrade, and test the functions without running > the ALTER EXTENSION UPGRADE. > > -- > Álvaro Herrera http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services Hi Alvaro,
I do not have a 9.3 environment. I did not change any previous existing code. Can anybody help me on the upgrade? Thanks, Liming -- Liming Hu cell: (435)-512-4190 Seattle Washington -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers