Re: error moving table to tablespace (8.0 beta win32 )

Christian Traber wrote:

Hi!

just playing with tablespaces...

- moved a existing table to a new tablespace
- tried to move it back to default tablespace
(ALTER TABLE accounts SET TABLESPACE pg_default;)

Got the following error in logfile:

ERROR:  could not create relation 1663/317186/317191: Permission denied

Any suggestions?

are you able to create new tables in the default tablespace ? 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

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=#

Best regards,
Christian

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

-- 

regds
Mallah.

Rajesh Kumar Mallah
+---------------------------------------------------+
| Tradeindia.com  (3,11,246) Registered Users 	    | 
| Indias' Leading B2B eMarketPlace                  |
| http://www.tradeindia.com/			    |
+---------------------------------------------------+