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
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 |