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.