Error "cannot compare arrays of different element types" when trying to ANALYZE
От | Florian G. Pflug |
---|---|
Тема | Error "cannot compare arrays of different element types" when trying to ANALYZE |
Дата | |
Msg-id | 4197E022.7050101@phlo.org обсуждение исходный текст |
Ответы |
Re: Error "cannot compare arrays of different element types" when trying to ANALYZE
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: