Re: [SQL] Table versions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Stef <svb(at)ucs(dot)co(dot)za>, Rod Taylor <rbt(at)rbt(dot)ca>, pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Table versions
Date: 2003-10-29 17:49:40
Message-ID: 15525.1067449780@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Greg Stark <gsstark(at)mit(dot)edu> writes:
> This still suffers from one major deficiency. The order that objects are
> outputed isn't necessarily consistent between databases. If I add tables to
> the development server but then add them to the production server in a
> different order the schema still shows differences even though the objects in
> the two databases are identical.

Yeah. Stef may be able to handle this by comparing single-table dumps
rather than an overall pg_dump. In the long run pg_dump's logic for
ordering objects needs a wholesale rewrite --- maybe that will happen
for 7.5.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Browne 2003-10-29 17:57:17 Re: pg_clog & vacuum oddness
Previous Message Greg Stark 2003-10-29 17:45:35 Re: [SQL] Table versions

Browse pgsql-sql by date

  From Date Subject
Next Message Bryan Encina 2003-10-29 17:53:52 Re: Help on update that subselects other records in table, uses joins
Previous Message Greg Stark 2003-10-29 17:45:35 Re: [SQL] Table versions