[GENERAL] Lost one tablespace - can't access whole database

Hi postgresql 9.1 on Ubuntu 10.04 My database was spread over multiple tablespaces, spread over mutliple discs. Now i lost one of the discs = one tablespace. The database does start, but when I try to access the database, it complains psql: FATAL: could not open file ... I tried to point the s

[GENERAL] manipulating anyarray columns

Hi, I have to deal with anyarray columns for the first time, and I've run into some trouble. I need to read the pg_stats.most_common_vals column, and read several items, i.e. most frequent values stored in the column. With a regular column (as for example most_common_freqs) I can do this SELEC