| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
| Cc: | "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>, David Steele <david(at)pgmasters(dot)net>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: deparsing utility commands |
| Date: | 2015-08-06 02:55:20 |
| Message-ID: | 20150806025519.GK2441@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2015-08-06 02:57:48 | Re: Freeze avoidance of very large table. |
| Previous Message | Noah Misch | 2015-08-06 01:39:26 | Re: Raising our compiler requirements for 9.6 |