jakob / jakob/Postico

Add support for Vertica

Open
#320 6 comments 2 reactions 0 assignees View on GitHub
enhancement
Dominant language
Python
Stars
485
Forks
8
PR merge metrics
No merged PRs in 30d

Description

This is not an issue, but probably an opportunity to serve the Vertica customer base. The tool works beautifully with Vertica using SQL view. HP Vertica does not come with a GUI client and other ones out there (DBeaver, DBVisualizer) are not as cool, simple and fast as Postico. Ofcourse I am biased because I am not a heavy user of these other tools.

No Schema/Table view shows up when connecting to the Db
`Postico[39519]: Failed to load children of : Error Domain=at.eggerapps.Postico Code=1 "Query failed" UserInfo={PG_DIAG_SOURCE_FUNCTION=throwRelationDoesNotExist, PG_DIAG_SEVERITY=ERROR, PG_DIAG_MESSAGE_PRIMARY=Relation "pg_namespace" does not exist, NSLocalizedRecoverySuggestion=PostgreSQL said: Relation "pg_namespace" does not exist, PG_DIAG_SQLSTATE=42V01, query=SELECT oid, nspname, nspname = ANY (current_schemas(true)) AS is_on_search_path FROM pg_namespace, NSLocalizedDescription=Query failed, PG_DIAG_SOURCE_LINE=3328, PG_DIAG_SOURCE_FILE=/scratch_a/release/24526/vbuild/vertica/Catalog/CatalogLookup.cpp}`

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the schema/table-loading failure when connecting to Vertica and inspect the reported query against pg_namespace. Determine which database-specific catalog behavior prevents the schema view from appearing; done means Vertica connections expose their schemas and tables without this query failure.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.