This gives the same error. I can select columns from the table
although select * gets the error. I tried making a copy of the
"maps" table using CREATE TABLE new table name (all columns) AS
SELECT all columns FROM maps; This also gave me the same error.
Carol
On May 22, 2008, at 1:57 PM, hubert depesz lubaczewski wrote:
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
