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

[Rajesh Kumar Mallah]

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