and
reconnect, the database tree still shows db2 but if I just click on it,
the same error dialog will appear.
Regards,
Shiming
Tom Lane wrote:
Tham Shiming <[EMAIL PROTECTED]> writes:
ctid(tid) xmin(xid) xmax(xid) datname(name)
(0,5) 2 2213800494 db2 (pgAdmin sa
Regards,
Shiming
Tom Lane wrote:
"Dave Page" writes:
Tham Shiming <[EMAIL PROTECTED]> 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
Well, not exactly support. We didn't create the duplicate databases, it
just appear suddenly out of nowhere, which was also odd.
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
Hi,
I've been getting duplicate databases within my server. Dropping one of
them works, but when I try to drop the other, psql will say that the
database does not exist.
For example:
db1
db1
db2
db3
db4
db4
db5
Running DROP DATABASE db1 for the first time works and I'm left with:
db1
db2
d
