DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=default;
	d=consistentstate.com;
	h=Received:From:Organization:To:Subject:Date:User-Agent:MIME-Version:Content-Type:Content-Transfer-Encoding:Content-Disposition:Message-Id:X-Identified-User;
	b=XZ2rqTdvPhMcwlerOsFR8uGz+1Go4dJSdl9iQZ4rZIzGzqh0DpBHG21hXDBrbk2CRyB0OzGGkEUXDCs8t7ahucE6FTwq8wuYutTGVUDPnfejzfyJA2P/nNENzVZBDz1w;
From: Kevin Kempter <kevink@consistentstate.com>
Organization: Consistent State
To: pgsql-admin@postgresql.org
Subject: pg_dump errors
Date: Thu, 3 Jun 2010 11:08:38 -0600
User-Agent: KMail/1.9.4
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <201006031108.38937.kevink@consistentstate.com>

Hi all;

I'm seeing these errors when running a pg_dump of the postgres database:

Running: [pg_dump --schema-only postgres > postgres.ddl]
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  could not find hash function for 
hash operator 33639
pg_dump: The command was: SELECT a.attnum, a.attname, a.atttypmod, 
a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, 
a.attisdropped, a.attlen, a.attalign, a.attislocal, 
pg_catalog.format_type(t.oid,a.atttypmod) AS atttypname FROM 
pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = 
t.oid WHERE a.attrelid = '34093'::pg_catalog.oid AND a.attnum > 
0::pg_catalog.int2 ORDER BY a.attrelid, a.attnum


Running: [pg_dump --data-only  postgres > postgres.dat]
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  could not find hash function for 
hash operator 33639
pg_dump: The command was: SELECT a.attnum, a.attname, a.atttypmod, 
a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, 
a.attisdropped, a.attlen, a.attalign, a.attislocal, 
pg_catalog.format_type(t.oid,a.atttypmod) AS atttypname FROM 
pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = 
t.oid WHERE a.attrelid = '34093'::pg_catalog.oid AND a.attnum > 
0::pg_catalog.int2 ORDER BY a.attrelid, a.attnum        


thoughts? (I'm on Version 8.4.3)


thanks in advance