ERROR: Unable to transform targetlist (internal error)

Wow, 6.5.2. That is very old. We recommend you upgrade to 7.3.1.

---------------------------------------------------------------------------

Bruno Baguette wrote:

Hello,

I'm getting a really strange error message : ERROR: Unable to transform
targetlist (internal error) when I do a precise query on my database...

I've two tables : Professeurs and ProfesseursDesComediens

efap=> \d Professeurs

Table = professeurs

+----------------------------------+----------------------------------+-----
--+

| Field | Type | Length|

+----------------------------------+----------------------------------+-----
--+

| idprofesseur | int4 not null default nextval ( | 4 |

| nom | varchar() not null | 100 |

| prenom | varchar() | 100 |

+----------------------------------+----------------------------------+-----
--+

Index: pk_idprofesseur

efap=> \d ProfesseursDesComediens

Table = professeursdescomediens

+----------------------------------+----------------------------------+-----
--+

| Field | Type | Length|

+----------------------------------+----------------------------------+-----
--+

| fk_idcomedien | int4 not null | 4 |

| fk_idprofesseur | int4 not null | 4 |

+----------------------------------+----------------------------------+-----
--+

Index: uniqueidprofcomediens

When I do this query :

SELECT Professeurs.IdProfesseur, Professeurs.Nom, Professeurs.Prenom,
EXISTS(SELECT * FROM ProfesseursDesComediens WHERE FK_IdComedien = 713 AND
Professeurs.IdProfesseur = ProfesseursDesComediens.FK_IdProfesseur) FROM
Professeurs;

I get this error message : ERROR: Unable to transform targetlist (internal
error)

What does that means exactly ? What is my error ???

Thanks in advance !

PS :I'm working on PostgreSQL 6.5.2 on a Debian linux server.

-------------------------------------------------
Bruno BAGUETTE - bruno.baguette@netcourrier.com

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073