Re: type unknown?

Carol Walter <walterc@indiana.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