Re: BUG #15581: CREATE TABLE IF NOT EXISTS error

From: Andres Freund <andres(at)anarazel(dot)de>
To: liuwanle2010(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15581: CREATE TABLE IF NOT EXISTS error
Date: 2019-01-09 16:05:33
Message-ID: 20190109160533.23y7hmjpf5hclvvx@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On 2019-01-09 02:12:54 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 15581
> Logged by: iG
> Email address: liuwanle2010(at)gmail(dot)com
> PostgreSQL version: 11.1
> Operating system: Debian 9
> Description:
>
> sql:
> create table if not exists z.user_20190110 partition of z.user for values
> from ('20190110') to ('20190111');
>
> messages:
> NOTICE: relation "user_20190110" already exists, skipping
> ERROR: table "user_20190110" is already distributed
> SQL 状态:42P16

This does not appear to be an error message emitted by plain
postgres. Area you using an extension like Citus? If so, that's likely
where you'd need to redirect this bug to.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2019-01-09 16:07:28 Re: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not free disk space
Previous Message bharath Ganesan 2019-01-09 11:34:10 Installation issue