Comments (5)
Sorry for wasting your time :)
Not at all. Glad you resolved it and I think it will be a good improvement to the synopsis to mention the ON_ERROR_STOP=1 flag.
Happy new year!
from pg_sample.
Hey @fegmorte. Sorry for the delay in responding.
What is the actual error? Because, yes, I would expect lots of \N and \n values in the output, but psql should interpret those fine.
from pg_sample.
Ah, maybe this is the issue?
https://stackoverflow.com/questions/20427689/psql-invalid-command-n-while-restore-sql
Try setting that -v value:
psql -v ON_ERROR_STOP=1
I always use that. I'll update the docs to include that.
from pg_sample.
Hi @mla
Thank you for your answer.
Sorry i didn't attach the error message but it is the one that you find in SO.
invalid command \N
I have seen this solution but it seems to only stop the import on the first error as it said in SO:
Is possible to switch psql to "stop on first error" mode and to find error
I will try -v ON_ERROR_STOP=1
and i will give you a feedback.
from pg_sample.
Thank you @mla ! it was due to a lack of extension hstore
.
Sorry for wasting your time :)
from pg_sample.
Related Issues (20)
- Make row ordering deterministic HOT 9
- Can't run on a read-only DB. HOT 9
- Is it possibe to use the --limit query based on the contents of one of the sample tables HOT 3
- Could not identify an equality operator for type json HOT 1
- Error using --random parameter HOT 5
- wildcards don't seem to be working in "--limit" HOT 1
- Export data with inserts statements HOT 4
- Version 1.13 missing from github releases HOT 2
- Use of uninitialized value $sample_fk_table in concatenation (.) or string at pg_sample-master/pg_sample line 685 HOT 1
- psql:mini.sql:254159: ERROR: permission denied: "RI_ConstraintTrigger_c_11890996" is a system trigger HOT 3
- Is there a way to export a sample by a table row? HOT 3
- sample_schema table naming greater than 63 characters HOT 10
- ERROR: operator does not exist: json = json at character 35 HOT 1
- docker image can't sample databases newer than postgres 14
- pg_sample doesn't correctly handle generated columns HOT 6
- Query with a list can`t be parsed
- [SOLVED] ERROR: could not identify an equality operator for type json HOT 3
- wildcards not working as expected in "--limit" HOT 2
- Data from the filter and only the filter
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pg_sample.