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

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