Cannot use `IF NOT EXISTS` when creating extensions

[Angel-Ponce]

Cannot use `IF NOT EXISTS` when creating extensions

[griffio]

🤔 It should already be in 2.0.2

sqldelight/dialects/postgresql/src/main/kotlin/app/cash/sqldelight/dialects/postgresql/grammar/PostgreSql.bnf

Line 402 in a82c184

create_extension_stmt ::= CREATE 'EXTENSION' [ IF NOT EXISTS ] extension_name [ WITH ] [ 'SCHEMA' id ] [ 'VERSION' extension_version ] [ CASCADE ]

(Though your screen shot shows "CREATE IF NOT EXISTS EXTENSION..." that is invalid)

Here is an example project https://github.com/griffio/sqldelight-postgres-textsearch/blob/master/src/main/sqldelight/griffio/migrations/V1__Initial_version.sqm that uses pg_trgm for improved text searching in Postgres.

Note: The big issue with using PostgreSql extensions with SqlDelight is that any functions and types that are loaded by the extension, SqlDelight will not recognise them. The example here shows this can be mitigated with creating a custom dialect module https://github.com/griffio/sqldelight-custom-dialect/tree/master adding in some of the text search functions