Re: change of table name - any help

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:scott.marlowe@ihs.com]
Sent: Wednesday, September 17, 2003 10:26 AM
To: chakkara rangarajan
Cc: pgsql-admin@postgresql.org

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.