Hello Mr.scott, Thx for the info and kind help. Can you please provide me any useful links about the nature of the problem. Rgds --Ranga
-----Original Message----- From: scott.marlowe [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 10:26 AM To: chakkara rangarajan Cc: [EMAIL PROTECTED] On Wed, 17 Sep 2003, chakkara rangarajan wrote: > Hi All, > > We have a development server running > > OS - Linux, 2.4.20-openmosix-r4 > > DB - postgresql 7.3 > > > > 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. > > > > 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. Postgresql is known to not work properly under Mosix. It may someday, but from what I've read the shared memory / semaphore system is at the heart of the problem. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster