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
