PostgreSQL - search_path problem

Anonymous
2013-04-17
2013-06-06

  • Anonymous
    2013-04-17

    Hi, I have a custom data type stored in public schema and I'm trying to add one row to another schema's table and one column in this table is that custom data type. That INSERT statement will execute BEFORE INSERT trigger, in which I compare that column's value with some text but I get:

    Error in query: ERROR: operator does not exist: public.my_data_type <@ text
    

    If I put

    SET search_path = another, public;
    

    before INSERT statement, it works fine.
    Would it be possible to add automatically public schema as "fallback" search_path next to current schema? (it's done like that in PhpPgAdmin for example)