Daylon Wilkins

POC for index changes

2

This implements a proof-of-concept for true Postgres indexes. ## Current Implementation The current index implementation relies on the methods used in GMS and Dolt, which are inherently MySQL-based. There are...

Added CREATE USER, ALTER USER, DROP USER

1

This adds support for `CREATE USER`, `ALTER USER`, and `DROP USER`. This also adds the related `ROLE` statements too, since the `USER` statements are essentially aliases for them. Next step...

Added WHEN support for triggers

2

This adds support for `WHEN` on triggers, which is _probably_ the last major trigger addition that we'll need for now.

Draft of tables as types

2

Direction of the Doltgres-side of changes for adding tables as types (which includes GMS changes since we do not support tables being treated as values for parameters outside of aggregate/window...

A Postgres user has mentioned that they would require `WITH RECURSIVE` support in Doltgres. https://www.postgresql.org/docs/15/queries-with.html#QUERIES-WITH-RECURSIVE A description of how it's used, along with some example code provided by the user:...

Right now, we don't support comments via `COMMENT ON`. Instead of failing, however, we ignore it and send a warning. We should add an actual implementation. https://www.postgresql.org/docs/15/sql-comment.html

Full passthrough of Doltgres overrides

1

Related PRs: * https://github.com/dolthub/go-mysql-server/pull/3303 * https://github.com/dolthub/doltgresql/pull/2009