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

From: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Error "cannot compare arrays of different element types" when trying to ANALYZE
Date: 2004-11-14 22:45:54
Message-ID: 4197E022.7050101@phlo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-14 23:21:14 Re: Error "cannot compare arrays of different element types" when trying to ANALYZE
Previous Message Michelle Konzack 2004-11-14 19:39:17 Re: PostGresql USENET Vote