* Peter Eisentraut <peter_e@gmx.net> [010826 20:23]:
> 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.
seems to happen on ANY table/index.
I.E. I couldn't dump ANY user DB's.
LER
>
> --
> Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749