Can you give a try updating the catalogs with ANALYZE command and re-check ?
--- Best Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Tue, Jun 21, 2011 at 2:22 AM, hyelluas <helen_yell...@mcafee.com> wrote: > profiler1=# select relname,reltablespace from pg_class where > relname='application_category'; > relname | reltablespace > ----------------------+--------------- > application_category | 0 > (1 row) > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/how-to-find-a-tablespace-for-the-table-tp4500200p4508040.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
