Rajesh Kumar Mallah wrote:
> are you able to create new tables in the default tablespace ?
Yes, permissions are ok.
looks
like a permission issue did you initdb a fresh folder see if the owner of $PGDATA/data/base is the user that running postmaster (usually postgres) . It works fine for me though
initdb was run by windows installer
Regds mallah
test=# \d t_b Table "public.t_b" Column | Type | Modifiers --------+---------+----------- a | integer | Tablespace: "space"
test=# ALTER TABLE t_b SET TABLESPACE pg_default;
ALTER TABLE
test=# SELECT version();
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.0beta1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.2 (Mandrake Linux 10.0 3.3.2-6mdk)
(1 row)
test=#
Maybe its only win32 version?
Here what i tried:
CREATE TABLE test (name varchar(100)); CREATE TABLE
CREATE TABLESPACE test LOCATION 'C:\\tmp\\ts_test'; CREATE TABLESPACE
\db
List of tablespaces
Name | Owner | Location
------------+----------+----------------
pg_default | postgres |
pg_global | postgres |
test | postgres | C:/tmp/ts_test
(3 rows)ALTER TABLE test SET TABLESPACE test; ALTER TABLE
\d+ test
Table "public.test"
Column | Type | Modifiers | Description
--------+------------------------+-----------+-------------
name | character varying(100) | |
Contains OIDs: yes
Tablespace: "test"ALTER TABLE test SET TABLESPACE pg_default; ERROR: could not create relation 1663/317186/1317654: Permission denied
select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.0beta1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mingw special 20030504-1)
(1 row)
Thanks and regards Christian
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
