Postgres Pro
Downloads
Home   >   mailing lists

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

From PG Bug reporting form
Subject BUG #15581: CREATE TABLE IF NOT EXISTS error
Date
Msg-id 15581-085ab3bb11d7e2fa@postgresql.org
Whole thread Raw
Responses Re: BUG #15581: CREATE TABLE IF NOT EXISTS error  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Thomas Munro
Date:
Subject: Re: BUG #15577: Query returns different results when executedmultiple times
Next
From: PG Bug reporting form
Date:
Subject: BUG #15582: ALTER TABLE/INDEX ... SET TABLESPACE does not free diskspace