http://www.slony.info/bugzilla/show_bug.cgi?id=209

           Summary: PGRES_FATAL_ERROR ERROR when installing slony in
                    postgresql 7.4.30 DB
           Product: Slony-I
           Version: 1.2
          Platform: All
        OS/Version: Linux
            Status: NEW
          Severity: major
          Priority: low
         Component: stored procedures
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: smorris328 at gmail.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


Created an attachment (id=96)
 --> (http://www.slony.info/bugzilla/attachment.cgi?id=96)
Script used to initialise slony

When installing slony into a postgresql 7.4.30 DB I got the following error:

<stdin>:21: loading of file
/home/smorris/postgresql/pgsql7430/bin//../share//slony1_funcs.v74.sql:
PGRES_FATAL_ERROR ERROR:  syntax error at or near "$" at character 4337
ERROR:  syntax error at or near "$" at character 4337

Having investigated this further it looks to me like the last function in the
/share//slony1_funcs.v74.sql file is not in the correct format for a 7.4.*
database.

I have altered it to:

create or replace function @NAMESPACE at .TruncateOnlyTable ( name) returns void
as
'
begin
    execute ''truncate ''|| @NAMESPACE at .slon_quote_input($1);
end;
'
LANGUAGE plpgsql;

and this seems to work.

I have attached my initialisation script.

Stuart

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.