Skip to content

postgresql column type date error #1541

@sunkainj

Description

@sunkainj
Reason: Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: FromSql(1), cause: Some(WrongType { postgres: Type(Date), rust: "core::option::Option<alloc::string::String>" }) }) })

generated model
model account {
  avatarpath     String
  birthday       DateTime
  email          String
  emailisvalid   Boolean  @default(false)
  gender         Boolean
  id             Int      @id
  lastactiveip   String
  lastactivetime DateTime
  mobile         String
  mobileisvalid  Boolean  @default(false)
  password       String
  qq             String
  realname       String
  regip          String
  regtime        DateTime
  roleid         Int
  username       String
  wx             String
}

table sql
-- DROP TABLE public.account;

CREATE TABLE public.account
(
    id integer NOT NULL DEFAULT nextval('account_id_seq'::regclass),
    username character varying(64) COLLATE pg_catalog."default" NOT NULL,
    password character varying(64) COLLATE pg_catalog."default" NOT NULL,
    email character varying(140) COLLATE pg_catalog."default" NOT NULL,
    mobile character varying(140) COLLATE pg_catalog."default" NOT NULL,
    gender boolean NOT NULL,
    birthday date NOT NULL,
    roleid integer NOT NULL DEFAULT (10)::smallint,
    avatarpath character varying(20) COLLATE pg_catalog."default" NOT NULL,
    regtime timestamp without time zone NOT NULL,
    regip character varying(15) COLLATE pg_catalog."default" NOT NULL,
    lastactivetime timestamp without time zone NOT NULL,
    lastactiveip character varying(15) COLLATE pg_catalog."default" NOT NULL,
    qq character varying(140) COLLATE pg_catalog."default" NOT NULL,
    wx character varying(140) COLLATE pg_catalog."default" NOT NULL,
    realname character varying(50) COLLATE pg_catalog."default" NOT NULL,
    mobileisvalid boolean NOT NULL DEFAULT false,
    emailisvalid boolean NOT NULL DEFAULT false,
    CONSTRAINT account_pkey PRIMARY KEY (id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.account
    OWNER to postgres;

node.js code

const { PrismaClient } = require('@prisma/client')

const prisma = new PrismaClient()

async function main() {
  const account = await prisma.account.findOne({ where: { id: 1 } })
  console.log(account)
}
main()

column birthday error occurred

I changed birthday type to timestamp without time zone, it works.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions