[jira] [Assigned] (HAWQ-147) pg_dumpall error when insert table into template1

["Lirong Jian (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lirong Jian reassigned HAWQ-147:
--------------------------------

    Assignee: Lirong Jian  (was: Lei Chang)

> pg_dumpall error when insert table into template1
> -------------------------------------------------
>
>                 Key: HAWQ-147
>                 URL: https://issues.apache.org/jira/browse/HAWQ-147
>             Project: Apache HAWQ
>          Issue Type: Bug
>          Components: Command Line Tools
>            Reporter: Dong Li
>            Assignee: Lirong Jian
>
> When run commands below:
> mkdir cdbfast_pgbkup
> psql -d postgres
> {code}
> \c template1
> CREATE TABLE mpp7191 (a int, b date, c char,
>                      d char(4), e varchar(20), f timestamp)
> WITH (orientation=parquet,appendonly=true)
> partition by range (b)
> subpartition by list (a)
> subpartition template (
> subpartition l1 values (1,2,3,4,5),
> subpartition l2 values (6,7,8,9,10) ),
> subpartition by list (e)
> subpartition template (
> subpartition ll1 values ('Engineering'),
> subpartition ll2 values ('QA') ),
> subpartition by list (c)
> subpartition template (
> subpartition lll1 values ('M'),
> subpartition lll2 values ('F') )
> (
>   start (date '2007-01-01')
>   end (date '2010-01-01') every (interval '1 year')
> );
> insert into mpp7191 VALUES (1,'2007-01-01','M','11','QA','2001-02-16 20:38:40');
> {code}
> pg_dumpall > ./cdbfast_pgbkup/bkupall
> psql -d gptest -f  ./cdbfast_pgbkup/bkupall
>  ERROR:  Append-Only relation 'mpp7191' gp_relation_node entry for segment file #1 without an aoseg entry (case #2) (cdbdatabaseinfo.c:1537)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)