libredb / libredb/libredb-studio

[BUG] on the monitoring page, the 3 action buttons show "Relation does not exist"

Open
#772 1 comment 0 reactions 0 assignees View on GitHub
bug loop:needs-moderator-action
Dominant language
TypeScript
Stars
726
Forks
119
Avg merge
7h 47m
Merged PRs (30d)
265

Description

## Description

At the monitoring URL, e.g.

```
https://libredb-studio.yourdomain.com.com/monitoring
```

There are these buttons:

Image

For tables in schemas apart from public, when clicking on any of them, we get the error

> relation "public.Mytable" does not exist

This behaviour is seen throughout the admin dashboard, not just monitoring.

## Steps to Reproduce

Same as description

## Expected Behavior

The correct schema is used for the table

## Actual Behavior

The public schema is used, resulting in the table not being found

## Screenshots

relation-not-found

## Environment
Please provide the following information:

- **LibreDB Studio Version**: 0.15.0

## Possible Solution

Query the correct schema instead of public.

Contributor guide

Open the contributing guide

Research direction

Start at the /monitoring page and follow the three action buttons into the admin dashboard query path. Reproduce the issue with a table in a non-public schema and inspect where the table name is assembled for the database request. Done means all three buttons use the table's actual schema instead of defaulting to public.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, typescript
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
65/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.