Jim C. Nasby wrote: > Watching the discussion about how to handle nextval() and keep it dump > compatible makes me wonder: would it be useful to encode database or > dump version info into dumps? ISTM it would make it much more feasible > to handle changes to how things work automatically.
Yes, we have talked about that, and it would work for pg_dump-generated dumps. What it might not work for cleanly are dumps moved a different way, or application changes, so while it might help in some cases, being able to get things working without the version info is desirable. If we ever get to a case where we _need_ to use it, it would be good to have, just in case. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match