Skip site navigation (1) Skip section navigation (2)

Re: Version String

From: Sam Nelson <samn(at)consistentstate(dot)com>
To: Greg Sabino Mullane <greg(at)turnstep(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Version String
Date: 2011-04-15 17:50:49
Message-ID: BANLkTi=yFeSQGeSLWnhRHMm2=X2_4dmBtQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Alright, thanks guys!  I'll start testing it out, see what happens.
---
===========================
Samuel Nelson
Consistent State
www.consistentstate.com
303-955-0509
===========================


On Thu, Apr 14, 2011 at 7:23 PM, Greg Sabino Mullane <greg(at)turnstep(dot)com>wrote:

>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
>
>
> > 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;;
>
> Alternatively, you could create a public version and create
> a user that sees that public version (or some other schema)
> before the pg_catalog one:
>
> CREATE FUNCTION public.version() RETURNS text LANGUAGE SQL IMMUTABLE
> AS $$ SELECT 'PostgreSQL 8.4.22, but really PgPlus 8.4.22'::text$$;
>
> ALTER USER odbc_fakeout SET search_path = public, pg_catalog;
>
> Also note that a change to pg_catalog will *not* survive a
> pg_dump and restore.
>
> Other approaches:
>
> * Ask EDB if there is a version that doesn't mangle version()
>
> * Recompile it yourself after fixing version()
>
> * Make a custom version() as above that actually parses the real
>  version() string, so as to return the correct version even after
>  you upgrade.
>
> * Patch the standard ODBC driver to grep for just numbers in the
>  version string, if they haven't already.
>
> - --
> Greg Sabino Mullane greg(at)endpoint(dot)com  greg(at)turnstep(dot)com
> End Point Corporation 610-983-9073
> PGP Key: 0x14964AC8 201104142113
> http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
> -----BEGIN PGP SIGNATURE-----
>
> iEYEAREDAAYFAk2nncYACgkQvJuQZxSWSsgNTwCfZTMJzr+Y2hCXOibl/P5XyYlw
> twQAoKBcuq6OdXEFXVv/mCYGGn7r6LnR
> =NOEW
> -----END PGP SIGNATURE-----
>
>
>

In response to

pgsql-admin by date

Next:From: Dan BirkenDate: 2011-04-15 20:45:05
Subject: Re: streaming AND file-based log-shipping?
Previous:From: Ray StellDate: 2011-04-15 13:09:51
Subject: Re: streaming AND file-based log-shipping?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group