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