Re: table called 'configuration' cannot be dropped

pá 8. 3. 2019 v 16:51 odesílatel Daniel McCue <dmccue128(at)gmail(dot)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

https://stackoverflow.com/questions/26489244/how-to-detect-query-which-holds-the-lock-in-postgres

Pavel

> Thanks,
> Dan McCue
>
>