IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
Haven't tried this personally, but maybe you could also install each version of SQL Extensions into a new schema (based on version number) in the same database, & point the synonyms to those instead.
Of course this is assuming IBM ever releases a new version of SQL Extensions for Netezza (I wouldn't hold your breath waiting for it)
I recommend installing SQLEXTN in a standalone database and adding "search_path = <database>" at the bottom of the "/nz/data/postgresql.conf", which makes it local to each application database.