BUG #15581: CREATE TABLE IF NOT EXISTS error

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15581: CREATE TABLE IF NOT EXISTS error

PG Doc comments form
The following bug has been logged on the website:

Bug reference:      15581
Logged by:          iG
Email address:      [hidden email]
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

Reply | Threaded
Open this post in threaded view
|

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

Andres Freund
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:      [hidden email]
> 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

Reply | Threaded
Open this post in threaded view
|

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

Wanle Liu
Thanks, 



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

刘万乐



Andres Freund <[hidden email]> 于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:      [hidden email]
> 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