table called 'configuration' cannot be dropped

From: Daniel McCue <dmccue128(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: table called 'configuration' cannot be dropped
Date: 2019-03-08 14:53:55
Message-ID: CAEnhctX=pqcOhC2jxmzyNfp8-xi1Q9bwsvaOd3vaYf2zLj2OSA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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?

Thanks,
Dan McCue

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2019-03-08 15:55:02 Re: table called 'configuration' cannot be dropped
Previous Message Peter Eisentraut 2019-03-08 11:00:40 Re: BUG #15631: Generated as identity field in a temporary table with on commit drop corrupts system catalogs