From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org, ranga(at)dvdstation(dot)com |
Subject: | Re: change of table name - any help |
Date: | 2003-09-19 09:36:35 |
Message-ID: | 3F6ACE23.7847E359@rodos.fzk.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
> We have a development server running
>
> OS - Linux development-server 2.4.20-openmosix-r4 #1 SMP Mon May 19
02:32:52
> PDT 2003 i686 Intel(R) Xeon(TM) CPU 2.40GHz GenuineIntel GNU/Linux
>
> 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.
>
Did you change the SEARCH_PATH variable?
Did I get this right:
You cannot
DROP TABLE postgres.ctcert_name ;
Mind, I left off the enclosing quotes.
And you cannot
CREATE TABLE postgres.ctcert_name( ... ) ;
My suspicion is you are using these quotes and you shouldn't.
Regards, Christoph
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Thomas | 2003-09-19 09:59:04 | Re: About Pgdump |
Previous Message | Ron Johnson | 2003-09-19 09:33:00 | Re: need for in-place upgrades (was Re: State of Beta 2) |
From | Date | Subject | |
---|---|---|---|
Next Message | Carlos Guzman Alvarez | 2003-09-19 10:24:49 | Re: Array Parameters on protocol 3.0 |
Previous Message | Nigel J. Andrews | 2003-09-19 06:43:53 | pgindented tsearch2 for 7.3.4 |