"Sabin Coanda" <sabin.coanda@xxxxxxxxxxxxx> writes: > The problem is when I check the structure difference between DD and DP. My > procedure is to use pg_dump to make a plain text dump of the two databases, > and compare them, ignoring the comments. All the procedures are sorted > identically, excepting those with the same name, but different arguments. > Do you know a method to get the same text dump ? Yeah, this has been complained about before. The problem is that pg_dump's DOTypeNameCompare() function sorts only by object name, and if the names are the same then by object OID (which typically boils down to being the creation order). Ideally we should get it to consider more data, such as the argument lists for similarly-named functions, before falling back on OID order. If you're not up to hacking a fix for that, you could try dropping the functions and re-creating them in the same order on both machines, so that the OID sort produces similar results. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
