Hey folks, I was setting up `sqldelight` with post...

# squarelibraries

[Mohammed Toufeeq Ahamed]

Hey folks, I was setting up sqldelight with postgres for ktor server, it turns out that sqldelight doesn't support `Postgres Extension`s, I want to have a non-null column with UUID as default, which is possible with uuid-ossp in postgres. Is ther any way that I will be able to set this up with sqldelight?

[leonhardt]

If you're only using UUID v4 and don't care about the underlying differences, I've found that using GEN_RANDOM_UUID() instead of UUID_GENERATE_V4() just works.

Beyond that I'm subscribed to this GitHub issue for updates on postgres extensions in case it's ever supported. You might also want to chime in on this discussion where @griffio has asked for input to prioritize presently unsupported postgres features.

[Mohammed Toufeeq Ahamed]

You mean GEN_RANDOM_UUID in this query just works fine for you, I get the compiler error doing so.

CREATE TABLE IF NOT EXISTS user(
    id         UUID PRIMARY KEY NOT NULL GEN_RANDOM_UUID(),
    name      TEXT NOT NULL UNIQUE,
    created_at TIMESTAMP     NOT NULL   DEFAULT CURRENT_TIMESTAMP,
);

Thanks for pointing to the issue, hope extensions are supported soon.

[griffio]

plus green Just to add @Mohammed Toufeeq Ahamed - You should be able to get it compiling with:

CREATE TABLE IF NOT EXISTS "user"(
    id        UUID PRIMARY KEY NOT NULL DEFAULT (gen_random_uuid()),
    name      TEXT NOT NULL UNIQUE,
    created_at TIMESTAMP     NOT NULL  DEFAULT CURRENT_TIMESTAMP
);

The user is a reserved word in Postgres, remove comma at the end of CURRENT_TIMESTAMP and gen_random_uuid() in parentheses for now - there is an issue with function calls in CREATE TABLE.
gen_random_uuid is built in from PostgreSQL 13

However, I have a PR for CREATE EXTENSION, but the problem is that extensions define new functions. We can’t know about or define every possible extension function available to PostgreSQL.
Once CREATE EXTENSION is available it would have to be down to the user to create an extended custom dialect to add in the functions for the extensions e.g https://github.com/cashapp/sqldelight/tree/master/sqldelight-gradle-plugin/src/test/custom-dialect

[Mohammed Toufeeq Ahamed]

Thanks, this helps!! I will keep an eye on EXTENSION support.👍

[leonhardt]

Once CREATE EXTENSION is available it would have to be down to the user to create an extended custom dialect to add in the functions for the extensions

@griffio that sounds like a great solution