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

* 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