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

2004-08-11 Thread Tom Lane
Christian Traber <[EMAIL PROTECTED]> writes: > Maybe its only win32 version? Well, I can't reproduce it on Unix. It seems awfully odd though that you can create tables in that tablespace to begin with but can't move them there. I'm cc'ing this to the pgsql-hackers-win32 to see if anyone there ha

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

2004-08-10 Thread Christian Traber
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 thoug

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

2004-08-10 Thread 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 re

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

2004-08-10 Thread Christian Traber
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 suggestio