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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error "cannot compare arrays of different element types" when trying to ANALYZE
Date: 2004-11-14 23:21:14
Message-ID: 27590.1100474474@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Florian G. Pflug" <fgp(at)phlo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florian G. Pflug 2004-11-15 00:11:41 Re: Error "cannot compare arrays of different element types"
Previous Message Florian G. Pflug 2004-11-14 22:45:54 Error "cannot compare arrays of different element types" when trying to ANALYZE