Hi
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.
Here is the tables definition:
Column | Type | Modifiers
-------------------+------------------------+----------------------------------------------------
self | datagraph."GOLink" | not null default nextval('datagraph.s_self'::text)
Bezeichnung | datagraph."Char" |
virtual | datagraph."Boolean" | default true
Mitarbeiter | datagraph."GOLinkList" |
Abteilungen | datagraph."GOLinkList" |
Memo | datagraph."Text" |
Leiter | datagraph."GOLink" |
PostfachLand | datagraph."GOLink" |
PostfachOrt | datagraph."Char" |
PostfachPLZ | datagraph."Char" |
PostfachPostfach | datagraph."Char" |
PLZ | datagraph."Char" |
Ort | datagraph."Char" |
Land | datagraph."GOLink" |
Strasse | datagraph."Char" |
Telefon | datagraph."GOLinkList" |
Telefax | datagraph."GOLinkList" |
eMail | datagraph."GOLinkList" |
BS Nummer | datagraph."Char" |
Aktiv | datagraph."Boolean" |
Eroeffnung | datagraph."Date" |
Schliessung | datagraph."Date" |
Eintritt | datagraph."Date" |
Austritt | datagraph."Date" |
TUI Agenturnummer | datagraph."Char" |
Bankverbindungen | datagraph."GOLinkList" |
Marke | datagraph."GOLink" |
Buchhaltungsinfo | datagraph."GOLink" |
Name | datagraph."Char" |
Oeffnungszeiten | datagraph."Text" |
Zusatz | datagraph."Char" |
HR Firma | datagraph."GOLink" |
www | datagraph."GOLinkList" |
Vertraege | datagraph."GOLinkList" |
Standortinfo | datagraph."GOLink" |
Marketinginfo | datagraph."GOLink" |
OnChange | datagraph."GOLinkList" |
Historie | datagraph."GOLinkList" |
The datatypes are all domains with the basetype being what the name suggest (e.g. datagraph."Date" is a domain with basetype date). GOLink has the basetype int8, which GOLinkList has the basetype int8[].
Google just returns one(!) hit when searching for the error-message, which points to the file generating the error "/cvsroot/pgsql/src/backend/utils/adt/arrayfuncs.c".
greetings, Florian Pflug
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
