On Thu, May 22, 2008 at 01:37:56PM -0400, Carol Walter wrote: > When I ran the query you specified I got relname of "pg_toast_16429. > When I ran the REINDEX TABLE pg_toast_16429 the system responds that > relation "pg_toast_16429" does not exist.
I think it should be pg_toast.pg_toast_16429 so: REINDEX TABLE pg_toast.pg_toast_16429; check relnamespace in pg_class for this table, and check it against pg_namespace to be sure. depesz -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin