Error: operator does not exist: integer = integer

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

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.

Restarting the server fixes the error.
Clodoaldo

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