Not Able to Delink the old tables

From: shabeer ece <shabeer(dot)engg(at)gmail(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Not Able to Delink the old tables
Date: 2013-04-23 08:01:51
Message-ID: CAMJq9+EgqO07cdnj2CcHi2_dSErQ+KzXQYCMi8NABiD5vTSrsQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

When i tried to delink the old tables i'm getting the following error

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 IF NOTICE: Lock SqlLOCK TABLE
fr.check_deny_2013_04_17 NOWAIT ; NOTICE: -20000
delink_partitions_tables

(1 row)

But in the pg_stat_activity there is no locked process & there is no
process running related to this process...

Thanks in Advance :)

SHABEER.

Browse pgsql-sql by date

  From Date Subject
Next Message Mauricio Cruz 2013-04-25 16:17:06 execute
Previous Message Wolfgang Meiners 2013-04-22 18:06:31 Re: check for overlapping time intervals