From: | jdnelson(at)dyn(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #14113: LIKE <parent> INCLUDING STORAGE bug? |
Date: | 2016-04-25 15:33:24 |
Message-ID: | 20160425153324.2722.87726@wrigleys.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: 14113
Logged by: Jon Nelson
Email address: jdnelson(at)dyn(dot)com
PostgreSQL version: 9.4.6
Operating system: Linux
Description:
Running 9.4.6 and 9.4.7, I think I have encountered a bug with INCLUDING
STORAGE.
The CREATE TABLE syntax with INCLUDING STORAGE would seem to suggest that
storage options on the parent table (such as fillfactor) are copied to the
new child table, but this doesn't appear to work:
jnelson=# create table p (column1 integer not null) with (fillfactor = 70);
CREATE TABLE
jnelson=# \d+ p
Table "public.p"
Column | Type | Modifiers | Storage | Stats target | Description
---------+---------+-----------+---------+--------------+-------------
column1 | integer | not null | plain | |
Options: fillfactor=70
jnelson=# create table c (like p including storage);
CREATE TABLE
jnelson=# \d+ c
Table "public.c"
Column | Type | Modifiers | Storage | Stats target | Description
---------+---------+-----------+---------+--------------+-------------
column1 | integer | not null | plain | |
jnelson=#
From | Date | Subject | |
---|---|---|---|
Next Message | John Lumby | 2016-04-25 15:45:48 | Re: BUG #14109: pg_rewind fails to update target control file in one scenario |
Previous Message | Julien Rouhaud | 2016-04-25 14:53:19 | Re: BUG #14109: pg_rewind fails to update target control file in one scenario |