Обсуждение: BUG #7970: How 's list all members in a special tablespace ( not as pg_global & pg_default )
BUG #7970: How 's list all members in a special tablespace ( not as pg_global & pg_default )
От
sunny99991982@yahoo.com.vn
Дата:
The following bug has been logged on the website: Bug reference: 7970 Logged by: How 's list all members in a special tablespace Email address: sunny99991982@yahoo.com.vn PostgreSQL version: 9.0.4 Operating system: Enterpride linux 5 x86_64 Description: = I tried this, which will get the list of tables belong to 'XYZ' tablespace. CREATE TABLESPACE TBS1 OWNER access LOCATION '/u03/tbs'; --> OK Create table public.SinhVien ( MaSV text, TenSV text, Sodt int ) tablespace TBS1; --> OK Insert into public.SinhVien (MaSV,TenSV,Sodt) Values ('001','Nguyen Van',123456789),('002','Nguyen Ha',987654321); --> OK select relname from pg_class where reltablespace=3D(select oid from pg_tablespace where spcname=3D'TBS1'); relname = --------- (0 rows) why's return 0 rows ? i don't know please help me.
Re: BUG #7970: How 's list all members in a special tablespace ( not as pg_global & pg_default )
От
Heikki Linnakangas
Дата:
On 19.03.2013 10:19, sunny99991982@yahoo.com.vn wrote: > I tried this, which will get the list of tables belong to 'XYZ' tablespace. > > CREATE TABLESPACE TBS1 OWNER access LOCATION '/u03/tbs'; > > --> OK > > Create table public.SinhVien ( MaSV text, TenSV text, Sodt int ) tablespace > TBS1; > > --> OK > > Insert into public.SinhVien (MaSV,TenSV,Sodt) Values ('001','Nguyen > Van',123456789),('002','Nguyen Ha',987654321); > > --> OK > > select relname from pg_class where reltablespace=(select oid from > pg_tablespace where spcname='TBS1'); > > relname > ---------0 > (0 rows) > > why's return 0 rows ? i don't know You didn't quote the tablespace name in the CREATE TABLESPACE statement, so it's actually called tbs1, in lower case. Try: select relname from pg_class where reltablespace=(select oid from pg_tablespace where spcname='tbs1'); - Heikki