Error when referencing itsself

[uvulpos]

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]

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

[k1LoW]

The drawing of ER diagrams relies on Graphviz and there is no such flag at present.

If you find a way to support this in Graphviz, please let us know!

[uvulpos]

fyi: https://gitlab.com/graphviz/graphviz/-/issues/2554

[uvulpos]

can someone support here and give some insights?
https://gitlab.com/graphviz/graphviz/-/issues/2554#note_1941974571