From: Jerry Sievers <gsievers19@comcast.net>
To: Sam Nelson <samn@consistentstate.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Version String
References: <BANLkTi=zihAHVEgdO1cowF8nT4LuJO6ngA@mail.gmail.com>
Date: Thu, 14 Apr 2011 19:23:49 -0400
In-Reply-To: <BANLkTi=zihAHVEgdO1cowF8nT4LuJO6ngA@mail.gmail.com> (Sam
	Nelson's message of "Thu, 14 Apr 2011 15:21:42 -0600")
Message-ID: <87y63cs9h6.fsf@comcast.net>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Sam Nelson <samn@consistentstate.com> 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@comcast.net
p: 305.321.1144