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

           Summary: explain_interval conf option is broken in 2.2
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


The explain_interval configuration option will make slon do an 'explain' for
longer running log selection queries.  This stopped working in 2.2

If set this to be one slon tries to do queries like the following:

"explain COPY ( select log_origin, log_txid, NULL::integer, log_actionseq,
NULL::text, NULL::text, log_cmdtype, NULL::integer, log_cmdargs from
"_disorder_replica".sl_log_script where log_origin = 5 and log_txid >=
"pg_catalog".txid_snapshot_xmax('1:1:') and log_txid < '13352185' and
"pg_catalog".txid_visible_in_snapshot(log_txid, '13352183:13352185:13352183')
union all select log_origin, log_txid, NULL::integer, log_actionseq,
NULL::text, NULL::text, log_cmdtype, NULL::integer, log_cmdargs from
"_disorder_replica".sl_log_script where log_origin = 5 and log_txid in (select
* from "pg_catalog".txid_snapshot_xip('1:1:') except select * from
"pg_catalog".txid_snapshot_xip('13352183:13352185:13352183') ) order by
log_actionseq) TO STDOUT" 

syntax error at or near "COPY"

Apparently you can't do an explain on a COPY.

-- 
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.