Re: Two 'identical' DB's not acting identically - Mailing list pgsql-general

From Tom Lane
Subject Re: Two 'identical' DB's not acting identically
Date
Msg-id 7576.1050414678@sss.pgh.pa.us
Whole thread Raw
In response to Re: Two 'identical' DB's not acting identically  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> Here is the output from running your three test queries on both dbs. The
> last two return more than one row on both machines, and the last one
> returns twice the number of error messages on the test db than on the
> live db.

You know, this could be a matter of a data discrepancy, like you somehow
loaded two copies of data into some table.  It'd be worth doing a
"select count(*)" on each table in each database to see if they agree.

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Two 'identical' DB's not acting identically
Next
From: Bruce Momjian
Date:
Subject: Re: [PERFORM] Yet Another (Simple) Case of Index not used