Re: type unknown?

Carol Walter <walterc(at)indiana(dot)edu> writes:
> Well, it''s a guess. A "CREATE VIEW" follows the line that specifies
> the warning. (An "ALTER TABLE" immediately precedes it.) This made
> me think that is was on a view; then I went through the views till I
> found one with a column called "collection". Is there another way I
> can isolate what's happening?

Try doing the restore with log_min_error_statement set to WARNING;
that would at least confirm whether you're looking at the right view
definition.

BTW, what PG version is this?

regards, tom lane