"Dave Page" <dpage@xxxxxxxxxxxxxxxxxx> writes: >> Tham Shiming <shiming@xxxxxxxxxxxxxx> writes: >>> OK, checking pg_shadow, the usesysid for each entry is unique. >>> pg_database, however, showed the duplicate databases. A >>> short sample output from pgAdmin. >>> >>> datname datdba >>> db1 101 >>> db1 101 >>> db2 102 >>> db3 103 >>> db3 103 >> >> Does anyone know what the underlying query is that pgadmin uses for >> this display? > pgAdmin wouldn't display anything like that unless the user entered the > query themselves, or did a 'view data' on pg_database (in which case it > would just be a select *, possibly with a user entered WHERE restriction > or an ORDER BY). Hmm. If it's not a join, the only explanation that comes to mind for phantom rows is transaction ID wraparound. Could we see the output of select ctid, xmin, xmax, datname from pg_database; regards, tom lane
