Sam Nelson <samn@xxxxxxxxxxxxxxxxxxx> writes: > Hi, list > > We're attempting to change the version string for a Postgres Plus > instance to sort of trick a standard Postgres ODBC driver into > connecting to the pgplus instance. Â I know there is a postgres > plus ODBC driver out there, but, while I don't know the specifics of > why, it's currently not being used, and I believe there's a good > reason for that (although we have asked and are waiting for a > response). > > So, is this doable? Â Is there a way to change the version string that postgres reports back to us? alter function pg_catalog.version() rename to version_old; create function pg_catalog.version() returns text as $$select 'fake version goes here'::text$$ language sql;; I am not making any claim as to this being a good practice :-) Try it though on your dev system and see what happens. > ---Â > =========================== > Samuel Nelson > Consistent State > www.consistentstate.com > 303-955-0509 > =========================== > -- Jerry Sievers Postgres DBA/Development Consulting e: gsievers19@xxxxxxxxxxx p: 305.321.1144 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
