Re: BUG #15581: CREATE TABLE IF NOT EXISTS error - Mailing list pgsql-bugs

From Wanle Liu
Subject Re: BUG #15581: CREATE TABLE IF NOT EXISTS error
Date
Msg-id CAMaUEgtzGTShrGoqTY20gb3iL5ejrEadoXeJ9aRLFp1sx51bsw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15581: CREATE TABLE IF NOT EXISTS error  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Thanks, 



-------------------------

刘万乐



Andres Freund <andres@anarazel.de> 于2019年1月10日周四 上午12:05写道:
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@gmail.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

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #15577: Query returns different results when executedmultiple times
Next
From: Robert Haas
Date:
Subject: Re: BUG #15577: Query returns different results when executedmultiple times