=?UTF-8?Q?Viktor_Bojovi=C4=87?= <viktor.bojovic@xxxxxxxxx> writes: > while restoring backup i have received these messages > WARNING: column "id" has type "unknown" > DETAIL: Proceeding with relation creation anyway. It's most likely a view with an output column that's an undecorated string literal. > I have tried to grep schema-only dump file, but i didn't find word unknown. > When i have extracted all mentioned ID fields i didn't find any field which > is not of type integer,smallint or varchar. > How can i find out which table has that unknown type? Try something like select attrelid::regclass, attname from pg_attribute where atttypid = 'unknown'::regtype; regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
