change of table name - any help

Поиск
Список
Период
Сортировка
От chakkara rangarajan
Тема change of table name - any help
Дата
Msg-id 200309171749.h8HHnqB3012183@microretail.net
обсуждение исходный текст
Список pgsql-hackers
<div class="Section1"><p class="MsoNormal"><font color="blue" face="Arial" size="2"><span style="font-size:
10.0pt;font-family:Arial;color:blue">Hi All,</span></font><p class="MsoNormal"><font color="blue" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:blue">We have a development server running</span></font><p class="MsoNormal"><font
color="red"face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:red">OS – Linux development-server 2.4.20-openmosix-r4 #1 SMP Mon May 19 02:32:52 PDT
2003i686 Intel(R) Xeon(TM) CPU 2.40GHz GenuineIntel GNU/Linux</span></font><p class="MsoNormal"><font color="red"
face="Arial"size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:red">Database - PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.2.1</span></font><pclass="MsoNormal"><font color="red" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:red"> </span></font><p class="MsoNormal"><font color="blue" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:blue"> </span></font><p class="MsoNormal"><font color="blue" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:blue">We have a table ctcert_name under postgres DB(postgres schema and postgres user is
theowner). Suddenly, this object started missing from the DB (I am the only</span></font><p class="MsoNormal"><font
color="blue"face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:blue">Person who connects to that server and did not drop/renamed it). When I tried to
recreatethe same table, the system threw me back an error, saying that “postgres.ctcert_name” already exists. I am
neitherable to drop or rename the table. </span></font><p class="MsoNormal"><font color="blue" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:blue"> </span></font><p class="MsoNormal"><font color="blue" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:blue">checked the DB logs and there is no drop/rename table statement in that.
</span></font><pclass="MsoNormal"><font color="blue" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:blue">I have the transaction logs, but not able to read, as they are not in the human
readableformat.</span></font><p class="MsoNormal"><font color="blue" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:blue">How can I decipher from the txn logs, if it captures the change
management.</span></font><pclass="MsoNormal"><font color="blue" face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:blue"> </span></font><p class="MsoNormal"><font color="blue" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:blue">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.</span></font><p class="MsoNormal"><font color="blue"
face="Arial"size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:blue">Your efforts are greatly appreciated.</span></font><p class="MsoNormal"><font
color="blue"face="Arial" size="2"><span style="font-size: 
10.0pt;font-family:Arial;color:blue"> </span></font><p class="MsoNormal"><font color="blue" face="Arial" size="2"><span
style="font-size:
10.0pt;font-family:Arial;color:blue">Rgds</span></font><p class="MsoNormal"><font color="blue" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:blue">--Ranga</span></font><p class="MsoNormal"><font color="blue" face="Arial"
size="2"><spanstyle="font-size: 
10.0pt;font-family:Arial;color:blue"> </span></font></div>

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: New thoughts about indexing cross-type comparisons
Следующее
От: Dennis Bjorklund
Дата:
Сообщение: Re: New thoughts about indexing cross-type comparisons