From: | Guillaume Lémery <glemery(at)comclick(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | CopyObject Error 635 |
Date: | 2001-02-09 15:15:12 |
Message-ID: | 3A840980.8010700@comclick.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I have a function like this :
CREATE FUNCTION calculPeriodesPourAccords()
RETURNS INT2
AS 'DECLARE
lrec RECORD;
lrec2 RECORD;
lint_id_regie INT4;
lint_num_campagne INT4;
lint_num_periode INT4;
ldt_date_trt TIMESTAMP;
BEGIN
ldt_date_trt := now();
-- On désactive toues les accords
UPDATE accord_editeur
SET affichage_possible = 0;
FOR lrec IN SELECT id_regie,
num_campagne,
num_periode
FROM periode
WHERE date_debut_periode <= ldt_date_trt
AND date_fin_periode > ldt_date_trt
AND nb_affichage < (max_affichage * 0.9)
AND nb_clic < (max_clic * 0.9)
LOOP
lint_id_regie = lrec.id_regie;
lint_num_campagne = lrec.num_campagne;
lint_num_periode = lrec.num_periode;
FOR lrec2 IN SELECT num_publicite
FROM publicite
WHERE date_debut_publicite <= ldt_date_trt
AND date_fin_publicite > ldt_date_trt
AND id_regie = lrec.id_regie
AND num_campagne = lrec.num_campagne
LOOP
UPDATE accord_editeur
SET affichage_possible = init_affichage_possible,
num_periode = lint_num_periode
WHERE id_regie = lint_id_regie
AND num_campagne = lint_num_campagne
AND num_publicite = lrec2.num_publicite;
END LOOP;
END LOOP;
VACUUM accord_editeur;
RETURN 1;
END;'
LANGUAGE 'plpgsql';
And, when I run it I've got the following error message :
ERROR: copyObject: don't know how to copy 635
What does it mean ?
Thanx,
Guillaume.
From | Date | Subject | |
---|---|---|---|
Next Message | Jose solo en casita | 2001-02-09 15:34:10 | ERROR Permission denied |
Previous Message | Richard Huxton | 2001-02-09 15:09:26 | SQL function problem in 7.1? |