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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Michelle Konzack
Дата:
Сообщение: Re: PostGresql USENET Vote
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error "cannot compare arrays of different element types" when trying to ANALYZE