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

["Dong Li (JIRA)" <ji...@apache.org>]

Dong Li created HAWQ-147:
----------------------------

             Summary: 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: Lei Chang


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)