Re: Two 'identical' DB's not acting identically

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Two 'identical' DB's not acting identically
Дата
Msg-id 7576.1050414678@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Two 'identical' DB's not acting identically  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Two 'identical' DB's not acting identically
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [PERFORM] Yet Another (Simple) Case of Index not used