Error when referencing itsself

uvulpos commented 3 weeks ago

What happened

I have a database with a role. A role can inherit from another role. Like for example the role chef inherits permissions from the role cook like using_knife or use_stove. But chef also have additional roles like buy_groceries. When cook gets a new role, chef should get it too. So I have a reference to itself

What you expected to happened

An arrow on the side to itself. Maybe even colorful to see its referencing to itsself. But not bothering other innocent tables

What stack trace or error message from tbls did you see?

none.

Anything else we need to know?

Environment

tbls version: 1.76.0
Database version: postgres latest
OS macOS Sonomo... something
Config ( .tbls.yml ):

# .tbls.yml

# DSN (Database Source Name) to connect database
dsn: postgres://postgres:postgres@localhost:5432/postgres?sslmode=disable

# Path to generate document
# Default is `dbdoc`
docPath: ./doc/schema

include:
   - public.*

Sql Command:

CREATE TABLE IF NOT EXISTS roles (
    id UUID DEFAULT uuid_generate_v4() PRIMARY KEY,
    name VARCHAR UNIQUE NOT NULL,
    inherit_from UUID,
    FOREIGN KEY (inherit_from) REFERENCES roles(id) ON DELETE SET NULL,
    CHECK (inherit_from <> id)
);

uvulpos commented 3 weeks ago

Just out of curiosity: Is there a flag to make these comments less... interfering?