Enrico Weigelt <weigelt@metux.de> writes:
> I'm doing regular (hourly) dumps and putting them into git
> (and automatically pushing it to several git servers).
> The problem is: the dumps are always differing (even if nothing
> happened in that db).
> CREATE TEMPORARY TABLE pgdump_oid (dummy integer) WITH OIDS;
> COPY pgdump_oid WITH OIDS FROM stdin;
> -22336387 0
> Is there any way to get rid of these differences ?
(1) don't specify --oids
or
(2) update to something newer than 8.0 ... we haven't emitted that
for a long time.
regards, tom lane