BUG #15581: CREATE TABLE IF NOT EXISTS error

Started by PG Bug reporting formover 7 years ago3 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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

#2Andres Freund
andres@anarazel.de
In reply to: PG Bug reporting form (#1)
Re: BUG #15581: CREATE TABLE IF NOT EXISTS error

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

#3Wanle Liu
liuwanle2010@gmail.com
In reply to: Andres Freund (#2)
Re: BUG #15581: CREATE TABLE IF NOT EXISTS error

Thanks,
https://github.com/citusdata/citus/issues/2087

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

刘万乐

Andres Freund <andres@anarazel.de> 于2019年1月10日周四 上午12:05写道:

Show quoted text

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