steps_for_partition_err.sql

-- steps to reproduce error with value partitioned table

create database gaiadb_err template=template0 encoding 'UTF8' lc_collate='C';

ALTER DATABASE gaiadb_err SET search_path TO public,admin;

alter database gaiadb_err set lc_messages='en-US';

\c gaiadb_err

select version ();

\i create_tables_ERR.sql

---------------------------------------


-- PLEASE unzip the test data before the copy statements !
-- PLEASE provide your own path to the copy statements!

-- the following file *_3E.csv is too little and successes with source_to_arrays_ERR.sql

truncate table source_imp;

-- copy source_imp from 'GaiaSource_262134-265343_3E.csv' with (format csv,NULL 'null');


-- the bnext file is an example for the error 
-- psql:source_to_arrays_ERR.sql:179: ERROR:  more than one row returned by a subquery used as an expression

truncate table source_imp;

copy source_imp from 'GaiaSource_131011-132722_1E.csv' with (format csv,NULL 'null');

\i source_to_arrays_ERR.sql