Lucas Possamai

Results 63 comments of Lucas Possamai

I'm having the same issue. The solution mentioned by @aus10powell did not work.

Hi! Yep.. I can give it to you if I could find it.... I've got the schema but was unable to find it... the error says: ``` Creating table "_pg_sample"."pg_catalog_pg_shseclabel"...

I see it trhough DBVISUALIZER: Table pg_catalog.pg_statistic: ``` CREATE TABLE pg_statistic ( starelid "OID" NOT NULL, staattnum SMALLINT NOT NULL, stainherit BOOLEAN NOT NULL, stanullfrac REAL NOT NULL, stawidth INTEGER...

@mla thanks.. The patch worked. *_But *_I got another error now =\ Error: `Copying "dm"."invoices" ("invoice_id") rows referenced from "_pg_sample"."dm_bill_items" ("invoice_id")... DBD::Pg::db do failed: ERROR: could not identify an equality...

@mla you've helped a lot! It would be great if you can have a look on that issue for me (When u have time of course) Thank you!

@mla I was also looking for a --exclude-table-data= option.. is there one using pg_sample? Cheers

@mla yep.. removing "**DISTINCT**" worked... Thanks for that! about my other question: on pg_dump docs: > --exclude-table=table > Do not dump any tables matching the table pattern. The pattern is...

well.. put the -limit="junk.\* = 0" option.. it's fine. Thanks for your help @mla Can close this issue

@mla The dump has been successfully created. Command: `./pg_sample dbname --data-only --file=all_data.sql --limit="public.* = 1000" --limit="dm.* = 1000" --limit="integrations.* = *" --limit="gorfs.* = 100" --limit="junk.* = 0" --verbose` I've just...

That's great @mla - Thanks for your time and help...