Re: Version String

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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@xxxxxxxxxxxx  greg@xxxxxxxxxxxx
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-----



-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux