Reporting Bugs
pgloader is a software and as such contains bugs. Most bugs are easy to solve and taken care of in a short delay. For this to be possible though, bug reports need to follow those recommandations:
- include pgloader version,
- include problematic input and output,
- include a description of the output you expected,
- explain the difference between the ouput you have and the one you expected,
- include a self-reproducing test-case
Test Cases to Reproduce Bugs
Use the inline source type to help reproduce a bug, as in the pgloader tests::
LOAD CSV FROM INLINE INTO postgresql://dim@localhost/pgloader?public."HS"
WITH truncate,
fields terminated by '\t',
fields not enclosed,
fields escaped by backslash-quote,
quote identifiers
SET work_mem to '128MB',
standard_conforming_strings to 'on',
application_name to 'my app name'
BEFORE LOAD DO $$ create extension if not exists hstore; $$, $$ drop table if exists "HS"; $$, $$ CREATE TABLE "HS" ( id serial primary key, kv hstore ) $$;
1 email=>foo@example.com,a=>b 2 test=>value 3 a=>b,c=>"quoted hstore value",d=>other 4 baddata