pgadmin-org / pgadmin-org/pgadmin4

Can'tedit json[] values in table view

Open
#9,094 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Feature
Dominant language
Python
Stars
3.8k
Forks
891
Avg merge
4d 7h
Merged PRs (30d)
8

Description

json[] table columns can be filled with data by sql statements.
Then if user edit such data in table view its contents is highlighted with error sign.
If user changes something in it - value can't be saved back to table. So UI editor doesn't support json[] value edition.

Version 9.4
Application Mode Desktop
Commit 7c74b7cdb764d54ba7f42e0644b3f1d3ee7c786f 2025-05-27
Python Version 3.12.3
Electron Version 35.4.0
Browser Chrome 134.0.6998.205

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Reproduce the issue in the table view using a PostgreSQL table with a json[] column populated by SQL, then try editing and saving the value. Compare the displayed validation error with the save failure; done means json[] values can be edited and saved successfully.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases, frontend
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 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.