Cannot use IF NOT EXISTS when creating extensions

[Angel-Ponce]

SQLDelight Version

2.0.2

SQLDelight Dialect

PostgreSQL

Describe the Bug

I'm trying to execute:

CREATE EXTENSION IF NOT EXISTS unaccent;

But it seems that it's not supported yet.

Stacktrace

No response

[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