Re: Win32 version question

On Wed, 2004-06-30 at 11:16, Merlin Moncure wrote:
> > In phpPgAdmin, I need to know if the backend supports tablespaces or
> > not.  What is the most reliable way of detecting that the backend is
> the
> > win32 native version and hence does not support tablespaces?  Version
> > string info?
> > 
> > Or alternatively, what is the most direct way of detecting its
> presence
> > or absence, regardless of backend OS?
> 
> Check the uptime...if it's greater than 7 days, it's not win32 :).
> 
> Seriously, you can check the version() string.  If it's got mingw init,
> it's win32 native.
> 

Does the win32 build have a pg_tablespace table? are there any rows in
it? 

Was thinking the combination of the two queries would be able to
determine table space support in some fashion:

select * from pg_class where relnamespace = (select oid from
pg_namespace where nspname = 'pg_catalog') and relname =
'pg_tablespace';

select count(*) from pg_tablespace ;


Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL