Skip site navigation (1) Skip section navigation (2)

Re: pg_dump failure, can't get data out...

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Larry Rosenman <ler(at)lerctr(dot)org>
Cc: PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_dump failure, can't get data out...
Date: 2001-08-27 01:27:44
Message-ID: Pine.LNX.4.30.0108270320070.699-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-hackers
Larry Rosenman writes:

> pg_dump: query to get function name of oid - failed: ERROR:  oidin:
> error in "-": can't parse "-"

It's trying to dump a functional index but the function appears to be
absent.  (Therefore the name comes out as '-'.)  It's hard to tell which
index this is because the query pg_dump uses does not ORDER BY, but if in
doubt you can try the query in pg_dump.c:getIndexes() yourself -- it will
be the first index.  Offhand I don't see a related change in pg_dump in
recent times, so it probably isn't necessarily an upgrade related issue,
it might be an inconsistent schema.

It might be easiest to remove the index in question before dumping.

-- 
Peter Eisentraut   peter_e(at)gmx(dot)net   http://funkturm.homeip.net/~peter


In response to

Responses

pgsql-hackers by date

Next:From: Hiroshi InoueDate: 2001-08-27 01:54:58
Subject: Re: linking hba.c
Previous:From: Larry RosenmanDate: 2001-08-27 00:54:22
Subject: Re: pg_dump failure, can't get data out...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group