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

* Peter Eisentraut <peter_e(at)gmx(dot)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(at)gmx(dot)net http://funkturm.homeip.net/~peter

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749