BUG #14113: LIKE INCLUDING STORAGE bug? - Mailing list pgsql-bugs

From jdnelson@dyn.com
Subject BUG #14113: LIKE INCLUDING STORAGE bug?
Date
Msg-id 20160425153324.2722.87726@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14113: LIKE INCLUDING STORAGE bug?
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14113
Logged by:          Jon Nelson
Email address:      jdnelson@dyn.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=#

pgsql-bugs by date:

Previous
From: georg.kahest@internet.ee
Date:
Subject: BUG #14112: sorting v and w is broken with et_EE locate
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #14113: LIKE INCLUDING STORAGE bug?