Re: change of table name - any help - Mailing list pgsql-admin

From scott.marlowe
Subject Re: change of table name - any help
Date
Msg-id Pine.LNX.4.33.0309171125500.7690-100000@css120.ihs.com
Whole thread Raw
In response to change of table name - any help  ("chakkara rangarajan" <ranga@dvdstation.com>)
Responses Re: change of table name - any help
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: "chakkara rangarajan"
Date:
Subject: Re: change of table name - any help
Next
From: "chakkara rangarajan"
Date:
Subject: Re: change of table name - any help