Re: Dropping a database that does not exist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tham Shiming <shiming(at)misatravel(dot)com>
Cc: "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Dropping a database that does not exist
Date: 2006-02-13 14:35:36
Message-ID: 28288.1139841336@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tham Shiming <shiming(at)misatravel(dot)com> 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?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2006-02-13 14:44:20 Re: Dropping a database that does not exist
Previous Message Richard Huxton 2006-02-13 13:55:20 Re: using schema-qualified names in INSERTs