Re: Win32 version question

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>, "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Subject: Re: Win32 version question
Date: 2004-06-30 22:06:07
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB34101AEA5@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> 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 ;

select count(*) from pg_tablespace;
works normally, but you can do something like this:

You can do this:
test=# create tablespace ts location 'c:/temp';
ERROR: tablespaces are not supported on this platform
test=#

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2004-06-30 23:15:17 Re: Compile Failue on win32 - pipe.c using ereport
Previous Message Robert Treat 2004-06-30 21:11:27 Re: Win32 version question