On 28.12.2010 22:44, Joel Jacobson wrote:
Sent from my iPhone
The problem I see with suffixing a sequence id to the objects with name collision is that one day the dump may name myfunc(int) as myfunc.sql and after an overloaded version is created, say myfunc(char, int), then the same myfunc(int) may be dumped in myfunc-2.sql, which again is non-deterministic.
I agree, good point!
Perhaps abbreviations are to prefer, e.g., myfunc_i, myfunc_i_c, etc to reduce the need of truncating filenames.
Also, it is a project policy that we do not introduce new features in back branches, so spending time on an 8.4.6 patch may not be the best use of your time.
My company is using 8.4 and needs this feature, so I'll have to patch it anyway :)
Start the easy way, by writing a (python|perl) filter for pg_dump -s output
Once this is done, convert it into a patch for pg_dump
--------------------------------------------
Hannu Krosing
http://www.2ndQuadrant.com/books/