Request a Demo
Home   >   mailing lists

Not Able to Delink the old tables - Mailing list pgsql-sql

From shabeer ece
Subject Not Able to Delink the old tables
Date
Msg-id CAMJq9+EgqO07cdnj2CcHi2_dSErQ+KzXQYCMi8NABiD5vTSrsQ@mail.gmail.com
Whole thread
List pgsql-sql
Tree view

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.

pgsql-sql by date:

Previous
From: Wolfgang Meiners
Date:
Subject: Re: check for overlapping time intervals
Next
From: Mauricio Cruz
Date:
Subject: execute