Обсуждение: pgagent.sql script

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size:
10.0pt;font-family:Arial">Hi,</span></font><p class="MsoNormal" style="text-indent:35.4pt"><font face="Arial"
size="2"><spanlang="EN-US" style="font-size:10.0pt;font-family:Arial">I cannot run the pgAgent.sql script. I always got
thiserror: “ERROR:  syntax error at or near "$" at character 23556”. This line only contains this:
$BODY$</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">              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
mypgAdmin client.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">              Is it possible to run these scripts from my Windows Box?</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="EN-US" style="font-size: 
10.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="EN-US"
style="font-size:
10.0pt;font-family:Arial">Thank you</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">RenaudFortier<br /></span></font><font face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial">Technicien en informatique <br /> Faculté des sciences de l'agriculture <br /> et de
l'alimentation- Direction <br /> Pavillon Paul-Comtois, local 3443 <br /> Université Laval <br /> Québec, Canada <br />
G1K7P4 <br /> Téléphone .... (418)656-2131, poste 4789 <br /> Télécopieur .. (418)656-7806 <br /> Courriel .....
</span></font><ahref="mailto:renaud.fortier@fsaa.ulaval.ca" title="mailto:renaud.fortier@fsaa.ulaval.ca"><font
face="Arial"size="2"><span
style="font-size:10.0pt;font-family:Arial">renaud.fortier@fsaa.ulaval.ca</span></font></a><br/><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family:Arial">Courriel ..... </span></font><a
href="mailto:rfortier@c2000.fsaa.ulaval.ca"title="mailto:rfortier@c2000.fsaa.ulaval.ca"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family:Arial">rfortier@c2000.fsaa.ulaval.ca</span></font></a><p
class="MsoNormal"><fontface="Times New Roman" size="3"><span style="font-size: 
12.0pt"> </span></font></div>

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