Re: change of table name - any help

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.