Hi,

I cannot run the pgAgent.sql script. I always got this error: “ERROR:
syntax error at or near "$" at character 23556”. This line only contains
this: $BODY$



I’m using pgAdmin 1.4.2 on a French Windows XP (I’m running
pgAdmin in English). My server is a v7.4.7 on a Debian Sarge box. I’m having
similar problem when a try to run Slony-I scripts from my pgAdmin client.



Is it possible to run these scripts from my Windows Box?



Thank you



Renaud Fortier
Technicien en informatique
Faculté des sciences de l'agriculture
et de l'alimentation - Direction
Pavillon Paul-Comtois, local 3443
Université Laval
Québec, Canada
G1K 7P4
Téléphone .... (418)656-2131, poste 4789
Télécopieur .. (418)656-7806
Courriel ..... <mailto:renaud.fortier@fsaa.ulaval.ca>
renaud.fortier@fsaa.ulaval.ca
Courriel ..... <mailto:rfortier@c2000.fsaa.ulaval.ca>
rfortier@c2000.fsaa.ulaval.ca

Renaud Fortier wrote:
>
> Hi,
>
> I cannot run the pgAgent.sql script. I always got this error: “ERROR:
> syntax error at or near "$" at character 23556”. This line only
> contains this: $BODY$
>
> I’m using pgAdmin 1.4.2 on a French Windows XP (I’m running pgAdmin in
> English). My server is a v7.4.7 on a Debian Sarge box. I’m having
> similar problem when a try to run Slony-I scripts from my pgAdmin client.
>
The $$ escaping was introduced in pgsql 8.0. While pgAgent should be
runnable on 7.3+, there might be other good reasons to upgrade to 8.0 or
even better 8.1.

Regards,
Andreas


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend