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/ |
+---------------------------------------------------+