Thread: Not Able to Delink the old tables

Not Able to Delink the old tables

From
shabeer ece
Date:
<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>