On Tuesday 02 August 2005 19:49, Tom Lane wrote: > Oliver Siegmar <o.siegmar@xxxxxxxxxx> writes: > > I did a hexdump on the files within the tabelspace directory...no > > business data at all, only postgres internals (I saw a lot of function > > names and datatypes). > > Would you look at pg_class in particular (file 1259) and confirm that it > contains only names of Postgres system catalogs and indexes, no tables > of your own? Everything in this file seems to be postgres related. Not a single table of our own. I removed the database directory and dropped the tablespace (by DROP TABLESPACE) successfully. Michael, Tom - thanks a bunch your help! Best Oliver ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match