Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christian Traber <christian(at)traber-net(dot)de>
Cc: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>,pgsql-general(at)postgresql(dot)org, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: error moving table to tablespace (8.0 beta win32 )
Date: 2004-08-11 23:35:17
Message-ID: 21884.1092267317@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers-win32
Christian Traber <christian(at)traber-net(dot)de> 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 has a clue ...

			regards, tom lane

> 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)

In response to

Responses

pgsql-hackers-win32 by date

Next:From: efesar (the kay)Date: 2004-08-12 01:39:45
Subject: 8.0 Beta 1 // Environment Vars // .pgpass
Previous:From: Tom HaddonDate: 2004-08-11 21:00:56
Subject: Re: Import from Linux to Windows

pgsql-general by date

Next:From: David FetterDate: 2004-08-11 23:54:53
Subject: Re: Coming soon: PG 7.4.4, 7.3.7, 7.2.5
Previous:From: Stephan SzaboDate: 2004-08-11 22:43:24
Subject: Re: How copy a new line char to a file?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group