* Peter Eisentraut <[EMAIL PROTECTED]> [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   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter

-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to