yugabyte/yugabyte-db

[YSQL] TablePlus unable to load tables without primary key

Open

#1,256 opened on Apr 25, 2019

View on GitHub
 (5 comments) (0 reactions) (1 assignee)C (1,003 forks)batch import
area/ysqlhelp wantedkind/bugpriority/medium

Repository metrics

Stars
 (8,229 stars)
PR merge metrics
 (Avg merge 17d 21h) (92 merged PRs in 30d)

Description

Jira Link: DB-1507 For tables that don't have a primary key, TablePlus is not able to load the table. Error displayed is ERROR: System column with id -1 is not supported yet

Contributor guide

Research direction
Investigate the code path in YSQL that handles system columns for tables without primary keys. The error 'System column with id 1 is not supported yet' suggests a missing check or handling for tables without primary keys when TablePlus queries system columns.
Tech stack
csqlpostgresql
Domain
database
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
SQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70