| From: | Tham Shiming <shiming(at)misatravel(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Dropping a database that does not exist |
| Date: | 2006-02-10 09:42:40 |
| Message-ID: | 43EC6010.70909@misatravel.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
db3
db4
db4
db5
Attempting to run DROP DATABASE db1 again will just give me "FATAL:
database "db1" does not exist"
Same scenario for db4.
I could ignore the error, but because of the duplicate database, I
cannot make a dump of the server.
Any one has any ideas why this is happening and how I can solve it? A
similar thing happened previously, but it was with tables within a
database. The only way we solved that was by dropping the database and
recreating the structure, which wasn't the ideal way I wanted to use.
I've got PostgreSQL 8.0.4 running on SuSE 9.3.
Regards,
Shiming
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Harper | 2006-02-10 10:16:39 | Re: implicit cast of empty string to timestamp |
| Previous Message | A. Kretschmer | 2006-02-10 09:36:46 | Re: implicit cast of empty string to timestamp |