[Postgres-xc-developers] SET search_path Not Distributed

[David E. W. <da...@ju...>]

XCers,

I have a script that looks like this:

    BEGIN;
    SET client_min_messages TO warning;
    SET search_path TO geo;

    CREATE TABLE continents (
        code      CHARACTER(2) PRIMARY KEY,
        continent TEXT         NOT NULL
    );

I ran this against a coordinator, and it seemed to work. But when I tried to select from the table, XC said it could not be found. \d geo.continents shows it, but only on the coordinator on which I ran the script. If I connect to any other coordinator or any data node, the continents table is in the public schema rather than the geo schema.

Bug? I don't see any mentinon of SET not being distributed in the SET docs:

  http://postgres-xc.sourceforge.net/docs/1_1/sql-set.html

I can work around it by schema-qualifying objects, but would rather not have to.

Thanks,

David