Re: Error "cannot compare arrays of different element types" when trying to ANALYZE

"Florian G. Pflug" <fgp@phlo.org> writes:
> Since sometime yesterday, my postgresql (7.4.5) reports
> "ERROR:  cannot compare arrays of different element types",
> when I analyze a specific table in my database.
> ...
> GOLink has the basetype int8, which GOLinkList has the basetype int8[].

I wonder whether you have somehow managed to store some GOLinkList
entries that internally show their element type as GOLink rather than
int8.  That shouldn't happen (since we don't support arrays of domain
types) but it would explain the error message.  Any idea what you did
to create this situation?

            regards, tom lane