This doesn't work, but I feel like it should... what am I missing? I tried two ways (s

UUID doesn't seem to work for inserts (Postgres) about kysely HOT 1 CLOSED

ee99ee commented on May 23, 2024

UUID doesn't seem to work for inserts (Postgres)

from kysely.

Comments (1)

koskimas commented on May 23, 2024 1

Kysely doesn't touch the data. It simply passes things to the underlying driver as parameters. https://kysely.dev/docs/recipes/data-types

You need to see the driver's documentation. In this case that's pg.

As the error message says, one option is an explicit cast:

function asUuid(id: string) {
  return sql<string>`${id}::uuid`
}

await db.insertInto('documents').values([
  {
    id: asUuid('b4d99282-e0e2-4407-a5c0-f63d830c9f62'),
    textract: '',
    created_at: new Date(),
    updated_at: new Date()
  }
]).execute();

from kysely.

Related Issues (20)

Web, Getting Started - MySQL dialect example produces type error HOT 4
`sql` tag function should be available on the `Kysely` interface HOT 1
Support ADD COLUMN IF NOT EXISTS and DROP COLUMN IF EXISTS
Feature request in adding ExecuteTakeFirstOrThrow HOT 3
`eb` assumes unknown operators to be arithmetic operators HOT 1
Adding a statement or node to the beginning of a query HOT 3
Add select from multiple tables and option to join other columns under alias HOT 1
Ensuring that queries use their transaction HOT 1
Typings broken with typescript 5.4.4: Type 'TB | ExtractTableAlias<DB, TE>' does not satisfy the constraint 'keyof DB' HOT 4
Rollback doesnt trigger on error HOT 2
Best practice for batch queries / mutations HOT 5
Merging multiple queries HOT 20
Suggestion: Allow Execution driver to execute multiple queries HOT 2
Dynamic case building HOT 3
Make mssql testable using apple silicon. HOT 5
Creating a Table from a Typescript interface HOT 3
Breaking change with addColumn between 0.27.2 and 0.27.3 HOT 4
Mapping field names between database and object HOT 1
Unable to create timetz with precision columns HOT 3
What should I type binary data as? HOT 2

UUID doesn't seem to work for inserts (Postgres) about kysely HOT 1 CLOSED

Comments (1)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent