From: | "chakkara rangarajan" <ranga(at)dvdstation(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | change of table name - any help |
Date: | 2003-09-17 17:54:40 |
Message-ID: | 200309171749.h8HHnqB3012183@microretail.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi All,
We have a development server running
OS - Linux development-server 2.4.20-openmosix-r4 #1 SMP Mon May 19 02:32:52
PDT 2003 i686 Intel(R) Xeon(TM) CPU 2.40GHz GenuineIntel GNU/Linux
Database - PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.2.1
We have a table ctcert_name under postgres DB(postgres schema and postgres
user is the owner). Suddenly, this object started missing from the DB (I am
the only
Person who connects to that server and did not drop/renamed it). When I
tried to recreate the same table, the system threw me back an error, saying
that "postgres.ctcert_name" already exists. I am neither able to drop or
rename the table.
checked the DB logs and there is no drop/rename table statement in that.
I have the transaction logs, but not able to read, as they are not in the
human readable format.
How can I decipher from the txn logs, if it captures the change management.
Can somebody please tell me, what cud have gone wrong and is the error is
reproduceable? What is the solution for this kind of problem.
Your efforts are greatly appreciated.
Rgds
--Ranga
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-17 17:55:37 | Re: New thoughts about indexing cross-type comparisons |
Previous Message | Dennis Bjorklund | 2003-09-17 17:07:06 | Re: New thoughts about indexing cross-type comparisons |