[New Extension]: pglinter

[pmpetit]

Is there an existing issue for this extension request?

• I have searched for an existing issue, and could not find a duplicate request.

Extension Name

pglinter

Project Repository URL

https://github.com/pmpetit/pglinter

Extension Website URL (Optional)

pglinter

Short Description

Linter for database design.
for example, create a table with:

• one pk on a column "id"
• then, create an index on it
• then add unicity constraint on it.
  This will create some duplicated indexes.

other example:

• create a table order in a schema "orders"
• create an other order_details in an other schema "public" with a fk on orders.order
  it is not strictly forbidden by pg, but recognize it will be quite tricky to maintain (refresh,dumps....)

pglinter is here to create a sarif report about those wrong design.

Main LICENSE Link

https://github.com/pmpetit/pglinter/blob/main/LICENSE

License Compliance

• The extension's license (linked above) complies with the list of allowed licenses.

Known Dependent Extensions

n/a

Component Owner and Maintenance Commitment

• I/My organization commit to becoming the Component Owner and maintaining the extension image in the future.

Additional Notes (Optional)

No response

GitHub Handles of Component Owners

pmpetit

Code of Conduct

• I agree to follow this project's Code of Conduct

[pmpetit]

Hi,
i can't push...

> git push
ERROR: Permission to cloudnative-pg/postgres-extensions-containers.git denied to pmpetit.
fatal: Could not read from remote repository.

Please make sure you have the correct access rights
and the repository exists.
~/github/postgres-extensions-containers feat/pglinter > 

i think i'm not in the codeowner as describe in the README.

Feel free to close this issue if this extension is not wanted.
Thx