cerc-io/go-ethereum
13
0
Fork 0
Code Issues 9 Pull Requests Packages Projects Releases 66 Wiki Activity

No-UPSERT mode #299

New Issue
Closed
opened 2023-01-10 02:57:15 +00:00 by i-norden · 0 comments
i-norden commented 2023-01-10 02:57:15 +00:00
Member
Copy Link

We currently ON CONFLICT DO UPDATE SET for a few tables (eth.header_cids, eth.state_cids, eth.storage_cids). For state_cids and storage_cids this is unnecessary here with the current natural primary key scheme. For header_cids it is only necessary in order to increment the times_validated (times seen) counter.

As a dependency in eth-statediff-service it will continue to be useful to be able to upsert to these (and other) tables in certain situations, so this mode can be toggled on and off at the indexer level.

We currently `ON CONFLICT DO UPDATE SET` for a few tables (`eth.header_cids`, `eth.state_cids`, `eth.storage_cids`). For `state_cids` and `storage_cids` this is unnecessary here with the current natural primary key scheme. For `header_cids` it is only necessary in order to increment the `times_validated` (times seen) counter. As a dependency in eth-statediff-service it will continue to be useful to be able to upsert to these (and other) tables in certain situations, so this mode can be toggled on and off at the indexer level.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels   
bug

   
critical

   
duplicate

   
enhancement

   
epic

   
help wanted

   
in progress

   
invalid

   
low priority

   
question

   
rebase

   
v1

   
v5

   
wontfix
  
Copied from Github

An issue or PR manually copied from GitHub.

  
Kind/Breaking

Breaking change that won't be backward compatible

  
Kind/Bug

Something is not working

  
Kind/Documentation

Documentation changes

  
Kind/Enhancement

Improve existing functionality

  
Kind/Feature

New functionality

  
Kind/Security

This is security issue

  
Kind/Testing

Issue or pull request related to testing

  
Priority
Critical
The priority is critical

  
Priority
High
The priority is high

  
Priority
Low
The priority is low

  
Priority
Medium
The priority is medium

  
Reviewed
Confirmed
Issue has been confirmed

  
Reviewed
Duplicate
This issue or pull request already exists

  
Reviewed
Invalid
Invalid issue

  
Reviewed
Won't Fix
This issue won't be fixed

  
Status
Abandoned
Somebody has started to work on this but abandoned work

  
Status
Blocked
Something is blocking this issue or pull request

  
Status
Need More Info
Feedback is required to reproduce issue or to continue work

No Label
bug
critical
duplicate
enhancement
epic
help wanted
in progress
invalid
low priority
question
rebase
v1
v5
wontfix
Copied from Github
Kind/Breaking
Kind/Bug
Kind/Documentation
Kind/Enhancement
Kind/Feature
Kind/Security
Kind/Testing
Priority
Critical
Priority
High
Priority
Low
Priority
Medium
Reviewed
Confirmed
Reviewed
Duplicate
Reviewed
Invalid
Reviewed
Won't Fix
Status
Abandoned
Status
Blocked
Status
Need More Info
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: cerc-io/go-ethereum#299
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?