"Florian G. Pflug" <fgp@xxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
