Not Able to Delink the old tables
| От | shabeer ece |
|---|---|
| Тема | Not Able to Delink the old tables |
| Дата | |
| Msg-id | CAMJq9+EgqO07cdnj2CcHi2_dSErQ+KzXQYCMi8NABiD5vTSrsQ@mail.gmail.com обсуждение исходный текст |
| Список | pgsql-sql |
<div dir="ltr"><p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:15px;vertical-align:baseline;clear:both;word-wrap:break-word;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:20px">Hi,<p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:15px;vertical-align:baseline;clear:both;word-wrap:break-word;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:20px">When i tried to delink the old tables i'm getting the following error<pstyle="margin:0px 0px 1em;padding:0px;border:0px;font-size:15px;vertical-align:baseline;clear:both;word-wrap:break-word;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:20px">NOTICE: SELECT COUNT(*) AS count from pg_tables where schemaname='fr'and tablename='check_deny_2013_04_17' CONTEXT: PL/pgSQL function "delink_partitions_tables" line 16 at IFNOTICE: Lock SqlLOCK TABLE fr.check_deny_2013_04_17 NOWAIT ; NOTICE: -20000<h2 style="margin:0px 0px 10px;padding:0px;border:0px;font-size:21px;vertical-align:baseline;word-wrap:break-word;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:1.1em!important">delink_partitions_tables</h2><p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:15px;vertical-align:baseline;clear:both;word-wrap:break-word;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:20px">(1 row)<p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:15px;vertical-align:baseline;clear:both;word-wrap:break-word;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:20px">But in the pg_stat_activity there is no locked process & there isno process running related to this process...<p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:15px;vertical-align:baseline;clear:both;word-wrap:break-word;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:20px">Thanks in Advance :) <p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:15px;vertical-align:baseline;clear:both;word-wrap:break-word;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:20px">SHABEER.</div>
В списке pgsql-sql по дате отправления: