Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> writes: > Following error message might be misleading,
> postgres=# create table t1 (a unknown); > ERROR: column "a" has pseudo-type unknown
> UNKNOWN is not exactly a pseudo-type.
Well, as I said to Michael just now, I think we should turn it into one now that we're disallowing it in tables, because "cannot be used as a table column" is more or less the definition of a pseudotype. In any case, the average user probably thinks UNKNOWN is a pseudotype, if they think about it at all. So I think this message is fine even if we left it as-is.