test1.sql

text/plain

Filename: test1.sql
Type: text/plain
Part: 0
Message: Re: Partitioning option for COPY
-- segfaults, probably uninitialised cache oid list

-- disabling cache fixes it
-- set copy_partitioning_cache_size = 0;

drop table parent cascade;

create table parent(i int);
create table c1 (check (i > 0 and i <= 1)) inherits (parent);

copy parent from stdin with (partitioning);
1
\.

drop table parent cascade;

create table parent(i int);
create table c1 (check (i > 0 and i <= 1)) inherits (parent);


copy parent from stdin with (partitioning);
1
\.