Lucas Possamai
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...