Обсуждение: Not Able to Delink the old tables

Поиск
Список
Период
Сортировка

Not Able to Delink the old tables

От
shabeer ece
Дата:

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.