Re: Information Schema DBMS VERSION wrong - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Information Schema DBMS VERSION wrong
Date
Msg-id 200508031031.47926.peter_e@gmx.net
Whole thread Raw
In response to Re: Information Schema DBMS VERSION wrong  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Am Freitag, 29. Juli 2005 06:28 schrieb Tom Lane:
> > The following query doesn't return the version of PostgreSQL currently
> > running, but rather the version of initdb that initialized the cluster:

> Not sure if it was really thought about, but seeing that (a) you can get
> the current version from "select version()" and (b) there isn't any
> other way to get the initdb version, it seems like this behavior is
> fine.

I thought about this and I don't like it.  It could just as well confuse 
people who are in the name of portability or whatever are trying to move 
their application to use the information schema.  If we wanted to have a way 
to get certain information, we should design an interface for it and not rely 
on an accident.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: MySQL to PostgreSQL for SugarCRM
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] Patch to fix plpython on OS X