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

           Summary: pg_stat_activity changed in 9.2
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: slonik
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


When running against a 9.2 beta database

 PGRES_FATAL_ERROR lock table "_disorder_replica".sl_config_lock; select
nl_backendpid from "_disorder_replica".sl_nodelock     where nl_nodeid =
"_disorder_replica".getLocalNodeId('_disorder_replica') and        exists
(select 1 from pg_catalog.pg_stat_activity                  where procpid =
nl_backendpid); - ERROR:  column "procpid" does not exist


test1=# \d pg_stat_activity ;
           View "pg_catalog.pg_stat_activity"
      Column      |           Type           | Modifiers 
------------------+--------------------------+-----------
 datid            | oid                      | 
 datname          | name                     | 
 pid              | integer                  | 
 usesysid         | oid                      | 
 usename          | name                     | 
 application_name | text                     | 
 client_addr      | inet                     | 
 client_hostname  | text                     | 
 client_port      | integer                  | 
 backend_start    | timestamp with time zone | 
 xact_start       | timestamp with time zone | 
 query_start      | timestamp with time zone | 
 state_change     | timestamp with time zone | 
 waiting          | boolean                  | 
 state            | text                     | 
 query            | text                     | 


procpid is now pid 

We will need to make this be conditional on the version of pg we are running
against.  
This patch will need to be applied against 2.1 and 2.2

Technically 1.2 and 2.0 aren't supported against 9.1 as is.

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