griff і⊙
griff і⊙
😞 It's not supported - I will add to the list keeping track of migrations https://github.com/griffio/sqldelight-postgres-01 When I have a chance in the next day or so - I should...
Btw - what would be a reason for needing `IF NOT EXISTS` on a column with SqlDelight? e.g a column was manually added to the database, not using migrate script,...
🤔 It should already be in 2.0.2 https://github.com/cashapp/sqldelight/blob/a82c18430fd2cdb7543a0740f1a833f58858adb7/dialects/postgresql/src/main/kotlin/app/cash/sqldelight/dialects/postgresql/grammar/PostgreSql.bnf#L402 (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`...
`?` is hard-coded in Transacter https://github.com/sqldelight/sqldelight/blob/f79bd8ae2cf991de6dccdb643376253402f665e1/runtime/src/commonMain/kotlin/app/cash/sqldelight/Transacter.kt#L330-L341 I will have a look and see if there is a fix similar to https://github.com/sqldelight/sqldelight/pull/5319
> Transacter has acess to the driver.. the implementation could be moved to the base driver and overriden by the `R2dbcDriver` ? The PR does that https://github.com/sqldelight/sqldelight/pull/5523 🔕 Sadly -...
Currently the escape hatch to run ad-hoc queries is to use `driver.execute` directly - same api the compiler uses in the generated Queries e.g ``` kotlin driver.execute(-1, "INSERT INTO my_table(xml)...
Will wait for build issues (emulator) to start working
Could be build failures are occurring after update to `gradle/actions/setup-gradle@v4` a couple of weeks ago, if that somehow triggered it to download an sdk from source again instead of the...
Yes, when a PreparedStatement object is created every time it is less efficient if you are executing the same query many times and just binding different values, looking at PostgreSql...
Sadly, I think this is an issue with PostgreSql JDBC see https://github.com/pgjdbc/pgjdbc/issues/1225 Currently the JDBC driver has no support for `Array` to `Array` - it does for single column types...