Hi All, We have a development server running OS – Linux development-server
2.4.20-openmosix-r4 #1 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 |
- Re: [HACKERS] change of table name - any help chakkara rangarajan
- Re: [HACKERS] change of table name - any help Christoph Haller
- Re: [HACKERS] change of table name - any help chakkara rangarajan
- Re: [HACKERS] change of table name - any ... Nigel J. Andrews