Re: table called 'configuration' cannot be dropped - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: table called 'configuration' cannot be dropped
Date
Msg-id CAFj8pRDfM7Pxd-_TEozu1uXL=0pNn1Ycx4tvP+LS_H+ZsnV_dA@mail.gmail.com
Whole thread Raw
In response to table called 'configuration' cannot be dropped  (Daniel McCue <dmccue128@gmail.com>)
Responses Re: table called 'configuration' cannot be dropped  (Daniel McCue <dmccue128@gmail.com>)
List pgsql-bugs


pá 8. 3. 2019 v 16:51 odesílatel Daniel McCue <dmccue128@gmail.com> napsal:
I am running Postgresql version 9.5.14 on Ubuntu linux 16.04.
My schema defines a table called configuration.
From psql:
# \d configuration
            Table "public.configuration"
     Column     |          Type          | Modifiers 
----------------+------------------------+-----------
 parametername  | character varying(64)  | not null
 parametervalue | character varying(256) | 
Indexes:
    "configuration_pkey" PRIMARY KEY, btree (parametername)

PROBLEM:
When in psql, I  type:
# DROP TABLE configuration;

psql just hangs.  No further output from psql.  
If I hit CTRL-C, it responds as expected with:

^CCancel request sent
ERROR:  canceling statement due to user request

But why is psql stuck on the DROP statement?
Is configuration a reserved word or pre-defined table? 
Do I need to rename the table?


 postgres=# create table public.configuration(xx int);
CREATE TABLE

postgres=# drop table public.configuration ;
DROP TABLE

you can see, the name is not reserved. Probably some queries in some long transactions holds a locks on this table.

you should to check locks


Pavel



Thanks,
Dan McCue

pgsql-bugs by date:

Previous
From: Daniel McCue
Date:
Subject: table called 'configuration' cannot be dropped
Next
From: Daniel McCue
Date:
Subject: Re: table called 'configuration' cannot be dropped