On Fri, Nov 9, 2012 at 12:29 PM, Albe Laurenz <[email protected]>wrote:
> Thalis Kalfigkopoulos wrote: > > A tablespace is created successfully and so is a test table in it: > > # CREATE TABLESPACE ts_name LOCATION '/path/to/tablespace/location'; > > # SET default_tablespace=ts_name; > > # CREATE TABLE ts_test_table; > > > > From the command line: > > $ cd /path/to/tablespace/location > > $ ls > > PG_9.1_201105231 > > $ cd PG_9.1_201105231/ > > $ ls > > 11955 > > $ cd 11955/ > > $ ls > > 24683 24687 24689 > > > > All files 2468x correspond to objects identifiable by oid2name: > > $ oid2name -d postgres -f 24683 > > From database "postgres": > > Filenode Table Name > > ------------------------- > > 24683 ts_test_table > > > > But these give nothing: > > $ oid2name -d postgres -f 11955 > > $ oid2name -f 11955 > > > > Any ideas what it refers to? > > oid2name | grep 11955 > > It is a database. > > Yours, > Laurenz Albe > Duh! :( Thanx Laurenz. Missed the forrest for the trees
