FazBrowse GitHub Viewer | Trending |
URL:
| Home
Tools: [Download Repo ZIP]   [Original HTTPS Page]

fix(postgres): round-trip timestamptz / bytea / jsonb / arrays in the grid by ZhuchkaTriplesix · Pull Request #858 · QueryaHub/Querya-Desktop · GitHub

fix(postgres): round-trip timestamptz / bytea / jsonb / arrays in the grid - #858

Merged
ZhuchkaTriplesix merged 1 commit into
devfrom
issue/789-postgres-grid-types
Sep 20, 2026
Merged

ZhuchkaTriplesix merged 1 commit into
devfrom
issue/789-postgres-grid-types

Conversation

Copy link
Copy Markdown
Member

Summary

  • Table Browser and SQL results encode cells as PG literals: ISO timestamps, \x hex for bytea, JSON text for jsonb, {1,2,3} for arrays — not Object.toString.
  • getTableSchema prefers udt_name so ARRAY / USER-DEFINED (enums, int[]) reach formatLiteral.
  • Grid validator skips scalar int/json checks on array types.

Test plan

  • Browse types_showcase.all_datetime — timestamptz is ISO, Save round-trips.
  • Browse types_showcase.all_binary_and_bits — bytea shows \xdeadbeef, Save persists.
  • Browse types_showcase.all_json_xml — jsonb is JSON text, not Dart Map.toString.
  • Browse types_showcase.all_arrays — int[] shows {1,2,3,42,999}.
  • Browse types_showcase.all_custom_entities — enum admin stays a quoted label on Save.

Closes #789

… grid

Schema uses udt_name so ARRAY / USER-DEFINED reach formatLiteral.
Display uses ISO timestamps, \x hex, JSON text, and PG array literals.
github-actions Bot added bug Something isn't working frontend Theme parser epic label: frontend data-grid Interactive data grid, cell editor, filtering, groupings labels Sep 20, 2026
ZhuchkaTriplesix merged commit 89e86f9 into dev Sep 20, 2026
4 checks passed
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

bug Something isn't working data-grid Interactive data grid, cell editor, filtering, groupings frontend Theme parser epic label: frontend

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant


Back | FazBrowse Home | New Git URL