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)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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:
If I put
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)