hasura / hasura/graphql-engine

Identify invalid row from hasura error on bulk insert

Open
#4,310 3 comments 3 reactions 0 assignees View on GitHub
c/server
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

I would like to be able to identify the row, that causes error on bulk insert (I'm inserting multiple objects of same type).

When inserting multiple rows to Postgres DB directly using SQL (INSERT INTO public."tableName" VALUES "row1", "row2";), I not only get an error, but also details like `DETAIL: Failing row contains "row1"`. Using details information, at least in my case, it would be possible to identify problematic row.

Contributor guide

Open the contributing guide

Research direction

No implementation files or tests are named. Start by tracing how Hasura's GraphQL bulk-insert errors from Postgres are handled, then determine where the failing row detail can be exposed; done means a bulk insert error identifies the invalid row.

Written by the indexing model from the issue text.

Assessment

Tech stack
graphql, postgres
Domain
api, backend, database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.