BUG #14113: LIKE <parent> INCLUDING STORAGE bug?

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=#

Responses

Browse pgsql-bugs by date

  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