Thread: Error: operator does not exist: integer = integer

postgresql.x86_64                             8.3.14-1PGDG.rhel5
postgresql-server.x86_64                      8.3.14-1PGDG.rhel5

ERROR:  operator does not exist: integer = integer
LINE 3:            inner join vendedor as v on a.vendedor_id = v.id
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

Any ideas?

Regards, Clodoaldo

2011/8/1 Clodoaldo Neto <clodoaldo.pinto.neto@gmail.com>

Clodoaldo Neto <clodoaldo.pinto.neto@gmail.com> writes:
> postgresql.x86_64                             8.3.14-1PGDG.rhel5
> postgresql-server.x86_64                      8.3.14-1PGDG.rhel5

> ERROR:  operator does not exist: integer = integer

> Any ideas?

Something nasty happened to the pg_operator catalog?

            regards, tom lane

On Mon, Aug 1, 2011 at 3:17 PM, Clodoaldo Neto
<clodoaldo.pinto.neto@gmail.com> wrote:

> Restarting the server fixes the error.

There are few things that get "fixed" in PostgreSQL by restarting the
server. That is not a recommended action to take to solve problems
with this software.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services