ERROR: Unable to transform targetlist (internal error)

From: "Bruno Baguette" <bruno(dot)baguette(at)netcourrier(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: Unable to transform targetlist (internal error)
Date: 2003-01-22 04:40:24
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAATBuXKOMvlkWzD3KJN6FWLMKAAAAQAAAAQTFqKikyckGfBgZCBBnatwEAAAAA@netcourrier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)baguette(at)netcourrier(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Faisal Abdullah 2003-01-22 05:19:04 unsubscribe
Previous Message Justin Clift 2003-01-22 04:20:20 Re: FW: ERROR: Relation "pg_user" does not exist