BUG #15581: CREATE TABLE IF NOT EXISTS error

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: liuwanle2010(at)gmail(dot)com
Subject: BUG #15581: CREATE TABLE IF NOT EXISTS error
Date: 2019-01-09 02:12:54
Message-ID: 15581-085ab3bb11d7e2fa@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-01-09 02:21:48 BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not free disk space
Previous Message Thomas Munro 2019-01-09 01:52:45 Re: BUG #15577: Query returns different results when executed multiple times