Problem with insert

From: Jerome Raupach <jraupach(at)intelcom(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Problem with insert
Date: 2000-08-23 12:51:00
Message-ID: 39A3C8B4.D972C2B7@intelcom.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The query:

INSERT INTO table_resultat( origine, service, noeud, rubrique,
nb_passage, temps, date)
SELECT DISTINCT temp2.origine, temp2.service, temp2.noeud,
temp2.rubrique, temp2.nb_passage, temp2.temps, temp2.date FROM temp2
WHERE not exists
( SELECT table_resultat.origine, table_resultat.service,
table_resultat.noeud, table_resultat.rubrique, table_resultat.date FROM
table_brut WHERE table_resultat.origine=temp2.origine AND
table_resultat.service=temp2.service AND
table_resultat.noeud=temp2.noeud AND
table_resultat.rubrique=temp2.rubrique AND
table_resultat.date=temp2.date )

produces the error :
ERROR: replace_vars_with_subplan_refs: variable not in subplan target
list

anyone can explain me ?

Thanks. Jerome.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-08-23 13:36:43 Re: minor comment fixes for ouiparse.awk
Previous Message Larry Rosenman 2000-08-23 12:45:59 minor comment fixes for ouiparse.awk