Re: [Postgres-xc-developers] SET search_path Not Distributed

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

On Jan 30, 2014, at 5:04 PM, David E. Wheeler <da...@ju...> wrote:

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

Another search_path issue: If you have schema-qualified a data type in a table column, queries will fail against that table:

    dwheeler=# create schema bar;
    CREATE SCHEMA
    dwheeler=# create type bar.lol as enum ('a', 'b');
    CREATE TYPE
    dwheeler=# create table bar.hey (lol bar.lol) DISTRIBUTE BY REPLICATION;
    CREATE TABLE
    dwheeler=# select * from bar.hey;
    ERROR:  type "lol" does not exist

I guess the workaround would be to set the search_path to include all my schemas on in all the coordinator and data node postgresql.conf files?

Thanks,

David