Postgres Pro
Downloads
Home   >   mailing lists

Re: Error "cannot compare arrays of different element types" when trying to ANALYZE - Mailing list pgsql-general

From Tom Lane
Subject Re: Error "cannot compare arrays of different element types" when trying to ANALYZE
Date
Msg-id 27590.1100474474@sss.pgh.pa.us
Whole thread Raw
In response to Error "cannot compare arrays of different element types" when trying to ANALYZE  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: Error "cannot compare arrays of different element types"
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Error "cannot compare arrays of different element types" when trying to ANALYZE
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Error "cannot compare arrays of different element types"