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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
