multi_insert_fail.sql

\set ECHO all
\timing on
drop table if exists big_sparse;
CREATE TABLE big_sparse (
    u_id integer NOT NULL,
    c_id integer DEFAULT 0 NOT NULL,
    a_id integer DEFAULT 0 NOT NULL,
    cr_id integer DEFAULT 0 NOT NULL,
    b integer,
    c_t_u text,
    l_date abstime DEFAULT now(),
    c_b double precision DEFAULT 0.0,
    d_b double precision,
    c_s text,
    c_s_u abstime,
    c_e_u abstime,
    co_b_r_ts abstime,
    e_a_s integer,
    c_c_i_l text,
    c_c_e_l text,
    ag_c_i_l text,
    ag_c_e_l text,
    c_c_t_l text,
    c_r_t_l text,
    c_m_t_l text,
    c_ci_t_l text,
    ag_c_t_l text,
    ag_r_t_l text,
    ag_m_t_l text,
    ag_ci_t_l text,
    c_l_t_l text,
    ag_l_t_l text,
    r_s_id smallint DEFAULT 1 NOT NULL,
    r_s text NOT NULL,
    i_u_l text,
    e_u_l text,
    f_l text,
    f smallint,
    e_s_l_e text,
    r_h_f_n text,
    cr_h smallint,
    cr_w smallint,
    n_b integer,
    cr_a_l text,
    e_id bigint NOT NULL,
    a_ex text,
    ca_b_a real[],
    su smallint DEFAULT 0 NOT NULL,
    h_b_f real[],
    p_id integer,
    ca_b_aj real[],
    ca_b_aj_i integer[]
)
WITH (fillfactor=10);

COPY big_sparse FROM stdin;
1688	700032834	700580073	704810483	25	foobar.grotxxxxxbarb/xxxxxdexyzzyen.xyzzyv=xxxxxxxxxxixxxxx&src=201002RAA9	2011-11-12 05:00:01+00	0	500	i	2010-10-31 04:00:00+00	\N	2011-11-12 05:00:01+00	113	\N	\N	\N	\N	US	\N	\N	\N	\N	\N	\N	\N	en	\N	5	Rxyzzyn	\N	foobar./|foobar.xyzzyatxyzzy.xyzzyk/|foobar.grotxyzzyroupbarb/|grotxyzzxyzzybarb|foobar.grotxyxyzzybarb/|foobar.xyzzyxyzzyily.xyzzy/|grotxyzzyancebarb|grotxyzzydog|foobar.grotxyzzyxyzzysbarbdog/|foobar.grotxyzzyaobarb/|grotxyzzxyzzywsbarb|foobar.xyzzyun.xyzzy/|foobar.grotogejbarb/|foobar.grotxyzzxyzzybarb/|foobar.grotogcdbarbdog/|grotxyzzyetbarb|foobar.grotxyzzyipobarb/|foobar.grotxyzzyaobarb/|grotxyzzyxyzzyiabarb|grotxyzzybarbdog	xyzzyign	2	1:1291|0|0 ABC DEF 36|0|0 OR 1290|0|0 ABC DEF 36|0|0 OR 13|0|0 ABC DEF 36|0|0 OR 84|2592000|0 ABC DEF 36|0|0 OR 83|2592000|0 ABC DEF 36|0|0 OR 82|2592000|0 ABC DEF 36|0|0 OR 12|0|0 ABC DEF 36|0|0	\N	0	0	25	\N	0	\N	\N	0	{1,1,1,1,1,0.200000003,0.400000006,0.600000024,0.800000012,1,1,1,1,1,1,1!
 ,1,1,1,1,1,1,1,1}	\N	\N	\N
\.