Re: Odd duplicate database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd duplicate database
Дата
Msg-id 22164.1231969003@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Odd duplicate database  (Madison Kelly <linux@alteeve.com>)
Ответы Re: Odd duplicate database
Список pgsql-general
Madison Kelly <linux@alteeve.com> writes:
> Alvaro Herrera wrote:
>> Please send along
>> select xmin, xmax, ctid, cmin, cmax, datname from pg_database;

> template1=# select xmin, xmax, ctid, cmin, cmax, datname from pg_database;
>   xmin | xmax |  ctid  | cmin | cmax |  datname
> ------+------+--------+------+------+------------
>    383 |    0 | (0,1)  |    0 |    0 | template1
>    384 |    0 | (0,2)  |    0 |    0 | template0
>    386 |    0 | (0,3)  |    0 |    0 | postgres
>    659 |    0 | (0,10) |    0 |    0 | deadswitch
>   3497 | 3625 | (0,35) |    0 |    0 | nexxia
> (5 rows)

So the "nexxia" row did get updated at some point, and either that
transaction failed to commit or we've got some glitch that made this
row look like it didn't.  Have you used any "ALTER DATABASE" commands
against nexxia?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs?
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs?