Comments (3)
dimitri
commented on May 18, 2024
You can have more information that with client-min-messages set to data, which is what happens if you use --verbose --debug. I'm going to add some docs about that option...
from pgloader.
chanmix51
commented on May 18, 2024
Ok, it s perfect for the ouput:
2014-04-03T13:08:45.202000Z ERROR Database error 23502: null value in column "rent_from" violates not-null constraint
DETAIL: Failing row contains (7982, 7982, fixed, null, null, none, null, null, none, null, null, null).
CONTEXT: COPY accommodation_period, line 481: "7982 7982 fixed \N \N none \N \N none \N \N \N"
2014-04-03T13:08:45.405000Z INFO Entering error recovery.
2014-04-03T13:08:45.405000Z INFO error recovery at 0/4498, next error at 481, loading 480 rows
2014-04-03T13:08:45.405000Z INFO error recovery at 481/4498, processing bad row
2014-04-03T13:08:45.405000Z INFO error recovery at 481/4498, trying 4017 rows
I am now going to sort out this field shift problem.
from pgloader.
dimitri
commented on May 18, 2024
Any new information about this case? Should we close it maybe?
from pgloader.
Related Issues (20)
- debian package version 3.6.9-1 mismatch with sources version 3.6.7 HOT 1
- MSSQL "Connection to the database failed for an unknown reason" but other tools can connect HOT 1
- URL paramter options=endpoint not working HOT 1
- pgloader repeatedly disconnecting from db during migration attempt HOT 3
- Feature: Configuration File for Type Conversion overrides?
- MySQL connection recognition failed
- can you provide a stable version as default?
- missing `pgloader-bundle-3.6.10.tgz` for 3.6.10 release HOT 2
- Option to migrate table without its data
- no tables are found in geopackage/sqlite file HOT 1
- Issue with pgloader migration from MySQL MariaDB to Supabase HOT 2
- MySQL conversion syntax error at or near "\" HOT 2
- SQLite - primary keys not transfered, unique index creation fails, reset sequences fail
- sqlite to postgresql (Windows + Docker) HOT 1
- Casting errors when using Redshift as a data source
- Option "rows per range" not working in PostgreSQL to PostgreSQL migration?
- MSSQL Materialize view is downloading all views instead of filtering & downloading only the ones passed in config. HOT 2
- Cannot import SQLite array columns for various types into PostgreSQL (`TEXT[]`, `NUMERIC[]`, `BYTE[]`)
- Postgres - pgloader - Column names are converted to lower case in PostgreSQL by default HOT 1
- postgres -> postgres include/exclude logic not working correctly HOT 1
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 pgloader.