Re: Odd duplicate database - Mailing list pgsql-general

From Tom Lane
Subject Re: Odd duplicate database
Date
Msg-id 22164.1231969003@sss.pgh.pa.us
Whole thread Raw
In response to Re: Odd duplicate database  (Madison Kelly <linux@alteeve.com>)
Responses Re: Odd duplicate database
List 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 by date:

Previous
From: Jeff Davis
Date:
Subject: Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs?
Next
From: Jeff Davis
Date:
Subject: Re: A better BETWEEN for DATEs, TIMEs and TIMESTAMPs?