I'm using DBeaver as an SQL editor with RisingWave, and I'm encountering errors when trying to use the Navigator feature. Specifically, I'm getting errors related to pg_depend not being found, and I'm unsure if Materialized Views are being recognized as tables. Here's the error message I'm seeing:
SQL Error [XX000]: ERROR: ParseError: Catalog error: table or source not found: pg_depend
ERROR: ParseError: Catalog error: table or source not found: pg_depend
ERROR: ParseError: Catalog error: table or source not found: pg_depend
ERROR: unnamed prepare statement not found
ERROR: unnamed prepare statement not found```
Can someone help me understand why this is happening and how to fix it?Bahador Nooraei
Asked on Jul 24, 2023
The errors you're encountering in DBeaver are due to the current lack of support for the pg_depend table in RisingWave. The development team is aware of this and is planning to add support for most tables, including pg_depend, within a few days. They will check the complexity and provide an ETA for when this will be resolved. Additionally, there was a recent fix submitted that should allow DBeaver to show materialized views, which suggests that the issue with recognizing Materialized Views as tables has been addressed. The fix can be found in this pull request: https://github.com/risingwavelabs/risingwave/pull/11179. It's also mentioned that supporting DBeaver might require a simple fix, and the team is prioritizing support for DBeaver before tackling pgadmin.