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

藤澤 qsecofr1 @ hotmail.com
2007年 7月 24日 (火) 15:03:03 JST


$B%*%V%8%'%/%HL>$NBgJ8;z>.J8;z$N:.:_$K$D$$$F!"M}2r$G$-$^$7$?!#(B
$BBgJ8;z>.J8;z$r0U<1$7$F%*%V%8%'%/%HL>$KIU$1$?$$;~$K!"!V(B"$B!W(B($BFs=E0zMQId(B)$B$r(B
$BMQ$$$k$s$G$9$M!#(B

psql$B$G!V(B"$B!W(B($BFs=E0zMQId(B)$B$rIU$1$:$K!"%F!<%V%k%9%Z!<%9$r:n @ .$7$F!"(B
$B<!$K$=$N%*%V%8%'%/%H$N(Bdrop$B$r9T$C$F$_$F!"$J$s$H$J$/M}2r$G$-$^$7$?!#(B
PostgreSQL$BFb$G$N%*%V%8%'%/%HL>$N4IM}$O!">.J8;z$G9T$o$l$F$$$k$h$&$G$9$M!#(B

------------------------------------------------------------------------
mmk=# create tablespace tspaceTest2 owner mmk location 'c:/TestData2';
CREATE TABLESPACE

mmk=# drop tablespace "tspaceTest2";
ERROR:  tablespace "tspaceTest2" does not exist

mmk=# drop tablespace "tspacetest2";
DROP TABLESPACE

------------------------------------------------------------------------


$B>0!"(B
pgAdminIII $B$G$O!"%*%V%8%'%/%HL>$N07$$$G!V(B"$B!W(B($BFs=E0zMQId(B)$B$G(B
$B0O$C$F$$$k$N$+$I$&$+!"$H$$$&%*%W%7%g%s$O8+$D$+$j$^$;$s$G$7$?!#(B


$BAa @ n$5$s!"HD3@$5$s!"$"$j$,$H$&$4$6$$$^$7$?!#(B


$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






pgsql-jp メーリングリストの案内