Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group