If you create 2 tables
CREATE TABLE control.log_data2 (
log_filename character varying(70) NOT NULL,
idbusiness_entity integer DEFAULT 0 NOT NULL,
loaded character(1) DEFAULT 'n'::bpchar NOT NULL,
row_count integer DEFAULT 0 NOT NULL,
log_date date DEFAULT '1970-01-01'::date NOT NULL,
load_attempts smallint DEFAULT '0'::smallint,
file_size integer DEFAULT 0 NOT NULL,
PRIMARY KEY (log_filename)
)
DISTRIBUTE BY REPLICATION;
CREATE TABLE control.log_data3 (
log_filename character varying(70) NOT NULL,
idbusiness_entity integer DEFAULT 0 NOT NULL,
loaded character(1) DEFAULT 'n'::bpchar NOT NULL,
row_count integer DEFAULT 0 NOT NULL,
log_date date DEFAULT '1970-01-01'::date NOT NULL,
load_attempts smallint DEFAULT '0'::smallint,
file_size integer DEFAULT 0 NOT NULL,
PRIMARY KEY (log_filename)
)
DISTRIBUTE BY HASH(log_filename);
INSERT INTO control.log_data2 (log_filename) VALUES ('test') ON CONFLICT DO NOTHING;
INSERT INTO control.log_data3 (log_filename) VALUES ('test') ON CONFLICT DO NOTHING;
On the first table you never get any rows ??
The second table works fine, surly this should not happen?
Running 9.5rc on Centos 7