[pgsql-jp: 38599] Re: PostgreSQL8.2.4 オブジェクト名の大文字小文字の混在はダメ？

[藤澤]

$BAa ＠ n$5$s$N>pJs$r3NG'$7$h$&$H!"(B
psql$B$G%F!<%V%k%9%Z!<%9$r:n ＠ .$7$h$&$H$7$F$$$k$N$G$9$,!"(B
$B;XDj$9$k%U%)%k%@$N%Q%9$N=q$-J}$,J,$+$j$^$;$s!#(B


$B#1!%(B
***************************************************************************
mmk=# create tablespace tspaceTest owner mmk location 'c:\TestData2';
WARNING:  nonstandard use of escape in a string literal
LINE 1: create tablespace tspaceTest owner mmk location 'c:\TestData2...
                                                        ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
ERROR:  tablespace location must be an absolute path

***************************************************************************
$B"M(B location$B6g$N(B 'c:\TestData2' $B$H$$$&5-=R$K$D$$$F!"(B
   $B%(%9%1!<%WJ8;z$H$J$C$F$$$k!V(B\$B!W$N;H$$J}$,IT ＠ 5$N$h$&$G$9$N$G!"(B
   $B0J2<$N$h$&$KBG$AD>$7$^$7$?$,!"$@$a$G$7$?!#(B

$B#2!%(B
***************************************************************************
mmk=# create tablespace tspaceMmk2 owner mmk location 'c:\\MMKData2';
WARNING:  nonstandard use of \\ in a string literal
LINE 1: create tablespace tspaceMmk2 owner mmk location 'c:\\MMKData...
                                                        ^
HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
ERROR:  could not set permissions on directory "c:/MMKData2": No such file or di
rectory

***************************************************************************


Windows$BHG$G$K;XDj$,J,$+$kJ}$$$i$C$7$c$$$^$7$?$i!"$*65$(2<$5$$!#(B
$B$h$m$7$/$*4j$$$7$^$9!#(B


$B4D6-(B
------------------------------------
Windows XP Professional SP2
VB2005  (.Net Framework 2.0)
PostgreSQL 8.2.4   ($B%m!<%+%k(BPC$B$KF3F~(B)
    - UTF-8
------------------------------------


$B!?F#_7(B



On Mon, 23 Jul 2007 16:16:22 +0900 (JST)
Ryo Hayakawa <ryo ＠ fastriver.net> wrote:

> $BAa ＠ n$H?=$7$^$9!#(B
> 
> From: $BF#_7(B <qsecofr1 ＠ hotmail.com>
> Subject: [pgsql-jp: 38592] Re: PostgreSQL8.2.4 $B%*%V%8%'%/%HL>$NBgJ8;z>.J8;z$N:.:_$O%@%a!)(B
> Date: Mon, 23 Jul 2007 15:46:02 +0900 (JST)
> Message-ID: <20070723154556.2AA6.QSECOFR1 ＠ hotmail.com>
> 
> > $BFs=E0zMQId$K$D$$$F$O!";HMQ!&L$;HMQ$NN>J}$G;n$7$^$7$?!#(B
> > $BBgJ8;z$N$_!"BgJ8;z>.J8;z:.:_$G$O!"$I$A$i$b%(%i!<$H$J$j$^$7$?!#(B
> > 
> > 
> > $B$A$J$_$K!"%F!<%V%k%9%Z!<%9$N:n ＠ .$O!"(BpgAdmin$B-7$G9T$$$^$7$?!#(B
> 
> $B;d$O(B pgAdmin III $B$r$$$8$C$?$3$H$,$J$$$N$G!"@hDx=i$a$F%@%&%s%m!<%I$7$F(B
> $B;n$7$F$_$^$7$?$,!"$I$&$b$3$l$G%F!<%V%k%9%Z!<%9$r:n ＠ .$9$k$H!"%F!<%V%k%9(B
> $B%Z!<%9L>$KFs=E0zMQId$r$D$1$F(B create tablespace $BJ8$rH/9T$7$F$$$k$h$&$K(B
> $B8+$($^$9!#(B
> 
> psql $B$+$i0J2<$N$h$&$K%F!<%V%k%9%Z!<%9L>$rFs=E0zMQId$G0O$^$J$$$G:n$j$J(B
> $B$*$7$F$_$k$H$$$+$,$G$7$g$&$+!#(B
> 
>  create tablesapce tspaceTest
>  owner foo
>  location '/path/to/tablepsace'
> 
> # pgAdmin III $B$GFs=E0zMQId$r$D$1$J$$$h$&$K$9$k%*%W%7%g%s$OL5$$$N$G$7$g(B
> # $B$&$+$M(B?
> 
> -- $B$O$d$+$o(B