From: Jerry Sievers <gsievers19@comcast.net>
To: Sam Nelson <samn@consistentstate.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Version String
Date: Thu, 14 Apr 2011 19:23:49 -0400
Message-ID: <87y63cs9h6.fsf@comcast.net> (raw)
In-Reply-To: <BANLkTi=zihAHVEgdO1cowF8nT4LuJO6ngA@mail.gmail.com>
References: <BANLkTi=zihAHVEgdO1cowF8nT4LuJO6ngA@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, samn@consistentstate.com
Subject: Re: Version String
In-Reply-To: <87y63cs9h6.fsf@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox