mla

Hi! Can you give me the part of your schema that involved the pseudo-type? I've never used pseudo-types before, so not sure what's happening. If you have a dump of...

I don't know why it's trying to sample pg_catalog.\* stuff. Try this patch. Make sure you use a test db. This is completely untested. ``` diff --- pg_sample.orig 2016-03-03 00:21:46.932012688...

Must have an issue with json columns. I'll have to try and reproduce it. Late now, sorry, but will try to investigate tomorrow.

> @mla I was also looking for a --exclude-table-data= option.. is there one using pg_sample? What would that do? Sorry, not following.

Looks like the JSON issue is related to the "SELECT DISTINCT" around line 620. It can't do the DISTINCT because it doesn't understand the equality. @lpossamai, try just removing that...

I bet it was the fact that we removed the DISTINCT. I'll investigate how to distinct w JSON columns. On Thursday, March 3, 2016, lpossamai [email protected] wrote: > @mla https://github.com/mla...

I think we need to convert the DISTINCT to be DISTINCT ON (). I'll try to work on it tomorrow. Thanks for working through this.

@lpossamai give this patch a try, please: ``` diff @@ -615,7 +617,8 @@ while ($num_rows) { # satisfy the fk table, except those already present. my $query = qq{ INSERT...

@lpossamai, you should never get an empty table, unless you request 0 rows. Getting more rows than requested is definitely not uncommon though. That will be dictated by the foreign...

@lpossamai try this patch, please: ``` diff --- a/pg_sample +++ b/pg_sample @@ -192,6 +192,8 @@ use Getopt::Long qw/ GetOptions :config no_ignore_case /; use DBI; use DBD::Pg 2.0.0; +binmode STDOUT, ':utf8';...