pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump errors
5+ messages / 2 participants
[nested] [flat]
* pg_dump errors
@ 2010-06-03 17:08 Kevin Kempter <kevink@consistentstate.com>
0 siblings, 1 reply; 5+ messages in thread
From: Kevin Kempter @ 2010-06-03 17:08 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump errors
@ 2010-06-03 17:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: Kevin Kempter <kevink@consistentstate.com>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2010-06-03 17:18 UTC (permalink / raw)
To: Kevin Kempter <kevink@consistentstate.com>; +Cc: pgsql-admin
Kevin Kempter <kevink@consistentstate.com> writes:
> pg_dump: Error message from server: ERROR: could not find hash function for
> hash operator 33639
Bizarre ... that command really oughtn't be invoking any non-builtin
operator, but the OID is too high for a builtin. What do you get from
"select 33639::regoperator"?
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump errors
@ 2010-06-03 17:30 Kevin Kempter <kevink@consistentstate.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Kevin Kempter @ 2010-06-03 17:30 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
On Thursday 03 June 2010 11:18, Tom Lane wrote:
> Kevin Kempter <kevink@consistentstate.com> writes:
> > pg_dump: Error message from server: ERROR: could not find hash function
> > for hash operator 33639
>
> Bizarre ... that command really oughtn't be invoking any non-builtin
> operator, but the OID is too high for a builtin. What do you get from
> "select 33639::regoperator"?
>
> regards, tom lane
postgres=# select 33639::regoperator
postgres-# ;
regoperator
----------------
abc.=(oid,oid)
(1 row)
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump errors
@ 2010-06-03 17:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: Kevin Kempter <kevink@consistentstate.com>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2010-06-03 17:45 UTC (permalink / raw)
To: Kevin Kempter <kevink@consistentstate.com>; +Cc: pgsql-admin
Kevin Kempter <kevink@consistentstate.com> writes:
> On Thursday 03 June 2010 11:18, Tom Lane wrote:
>> Bizarre ... that command really oughtn't be invoking any non-builtin
>> operator, but the OID is too high for a builtin. What do you get from
>> "select 33639::regoperator"?
> postgres=# select 33639::regoperator
> postgres-# ;
> regoperator
> ----------------
> abc.=(oid,oid)
> (1 row)
So where did that come from, and why is it defined incorrectly?
(Evidently it's marked oprcanhash but there is no associated hash
opclass.) I can hardly see a reason to define your own oid equality
operator, much less a wrong one ...
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: pg_dump errors
@ 2010-06-03 20:29 Kevin Kempter <kevink@consistentstate.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Kevin Kempter @ 2010-06-03 20:29 UTC (permalink / raw)
To: pgsql-admin; +Cc: Tom Lane <tgl@sss.pgh.pa.us>
On Thursday 03 June 2010 11:45, Tom Lane wrote:
> Kevin Kempter <kevink@consistentstate.com> writes:
> > On Thursday 03 June 2010 11:18, Tom Lane wrote:
> >> Bizarre ... that command really oughtn't be invoking any non-builtin
> >> operator, but the OID is too high for a builtin. What do you get from
> >> "select 33639::regoperator"?
> >
> > postgres=# select 33639::regoperator
> > postgres-# ;
> > regoperator
> > ----------------
> > abc.=(oid,oid)
> > (1 row)
>
> So where did that come from, and why is it defined incorrectly?
> (Evidently it's marked oprcanhash but there is no associated hash
> opclass.) I can hardly see a reason to define your own oid equality
> operator, much less a wrong one ...
>
> regards, tom lane
I dont know where it came from. I havent intentionally defined any classes, or
anything like this. However this is a dev instance so maybe something went
wrong at some point.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-06-03 20:29 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-03 17:08 pg_dump errors Kevin Kempter <kevink@consistentstate.com>
2010-06-03 17:18 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-06-03 17:30 ` Kevin Kempter <kevink@consistentstate.com>
2010-06-03 17:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-06-03 20:29 ` Kevin Kempter <kevink@consistentstate.com>
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