Skip site navigation (1) Skip section navigation (2)

Re: More than one pg_database entry for database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "James Wilford" <jwilford(at)mistral(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: More than one pg_database entry for database
Date: 2007-07-05 16:26:44
Message-ID: 18569.1183652804@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"James Wilford" <jwilford(at)mistral(dot)net> writes:
> Its PG version 7.3.

Please tell us it's a relatively recent 7.3.x, at least ...

> I've just tried all your suggestions and
> unfortunately I still can't delete the bogus row. I think I managed to
> reindex the system tables:

Curious.  I'd have thought the reindex would fail because of the
duplicate datname entries.

> And trying ctid didn't work, assuming this syntax is correct:
> backend> delete from pg_database where ctid = '(0,37)';

Even more curious.  I'm starting to think it's some sort of XID
wraparound problem, except if you can see it in SELECT then why doesn't
the DELETE see it?

Could you show all the system columns of pg_database, viz

select xmin, cmin, xmax, cmax, oid, ctid, datname from pg_database;

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: James WilfordDate: 2007-07-05 16:38:48
Subject: Re: More than one pg_database entry for database
Previous:From: James WilfordDate: 2007-07-05 16:16:39
Subject: Re: More than one pg_database entry for database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group