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
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 |