Missing referenced rows #66
Description
Thank you for this very useful tool. I've searched exactly for this tool instead of doing it by hand.
After running it with different options, I discover an issue. As far as I know, the tool is supposed to follow foreign references and should add eventually more rows than specified with the option --limit. But in our case, not all foreign keys are followed. Some tables have exactly the same number as the given limit and do not cover all the entries of its foreign table.
I saw the following message for more than half of the Copying lines (i.e. one for each foreign key, I assume) while the tool was running:
Copying "public"."filter" (filter_name) rows referenced from "_pg_sample"."public_fluxes" (filter_name)... 0E0 rows
By comparing with the original DB, I know that more than 0 rows should have been returned,
Some of my tables are designed with primary keys made of more than one column. Could it be the origin of this issue?
Do you have an idea?
Note that this is not critical for me. It would be great to have all references working, but my goal was to have a not too bad sample of my database.