Jim Nasby wrote:
> On 7/31/15 8:45 AM, Shulgin, Oleksandr wrote:
> >STATEMENT: create view v1 as select * from t1 ;
> >ERROR: operator does not exist: pg_catalog.oid = pg_catalog.oid at
> >character 52
> >HINT: No operator matches the given name and argument type(s). You
> >might need to add explicit type casts.
> >QUERY: SELECT * FROM pg_catalog.pg_rewrite WHERE ev_class = $1 AND
> >rulename = $2
> >CONTEXT: PL/pgSQL function test_ddl_deparse() line 1 at FOR over SELECT
> >rows
> I'm not sure what test_ddl_deparse is doing, is that where the oid = oid is
> coming from?
>
> It might be enlightening to replace = with OPERATOR(pg_catalog.=) and see if
> that works.
That worked, thanks!
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services