Richard Huxton <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> This could be repaired by doing >> pg_resetxlog with a more appropriate initial transaction ID, but >> figuring out what that value should be is not easy :-(
> Tom - would there be any value in adding this to a pg_dump? Possibly. CVS tip pg_dump has been changed to not output OIDs by default, as a result of gripes from people who wanted to be able to "diff" dumps from different servers and not have the diff cluttered by irrelevant OID differences. But a single header line showing current XID and OID values doesn't seem like it would be a big problem. We could put current timestamp there too, which was another recent topic of discussion. Bring it up on pghackers and see if anyone has an objection... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match