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

           Summary: replication failure where column domain/type is in a
                    schema outside of search_path
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: major
          Priority: low
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: slony20121121 at throwaway.weebeastie.net
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


I'm using Slony 2.2.0b1 (tarball) with PostgreSQL 9.2.

iservices is the database
ipostoffice is the schema
postoffices is the table
potype_t is the domain/type and it's defined in the ipostoffice schema

The slony user does not have ipostoffice in its search_path.

When replication is attempted the following hits PostgreSQL:

[slony at iservices] ERROR:  42704: type "potype_t" does not exist at character
104
[slony at iservices] QUERY:  INSERT INTO "ipostoffice"."postoffices" ("id",
"postoffice", "potype") VALUES ($1::int4, $2::text, $3::potype_t);
[slony at iservices] CONTEXT:  COPY sl_log_1, line 1: "1   50213   23001   1      
ipostoffice     postoffices     I       0      
{id,2,postoffice,w.x.y.z,potype,hosted}"
[slony at iservices] LOCATION:  typenameType, parse_type.c:204

Problem here is that $3::potype_t /really/ needs to be
$3::ipostoffice.potype_t.

The following, though, work:

insert into postoffices (id,postoffice,potype) values (3,'w.x.y.z','hosted');
works where the user has the schema in their path
insert into ipostoffice.postoffices (id,postoffice,potype) values
(4,'w.x.y.zz','hosted'); where the user does not
insert into ipostoffice.postoffices (id,postoffice,potype) values
(5,'w.x.y.zzz','hosted'); works as the slony user (which does not)

This setup works fine with 2.0.3rc3 and PostgreSQL 8.3.

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