From: Kevin Kempter <kevink@consistentstate.com>
To: pgsql-admin@postgresql.org
Subject: pg_dump errors
Date: Thu, 3 Jun 2010 11:08:38 -0600
Message-ID: <201006031108.38937.kevink@consistentstate.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kevink@consistentstate.com
Subject: Re: pg_dump errors
In-Reply-To: <201006031108.38937.kevink@consistentstate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox