understanding rust types converts to pg types.

[madelaney]

I have a basic struct

pub struct Data {
  pub start: NaiveDate,
  pub end: NaiveDate,
  pub state: String,
  pub offset: i64,
}

which I have a schema:

CREATE TABLE IF NOT EXISTS data (
  id varchar(36) NOT NULL,
  offset int4,
  state varchar(5),
  start_date date,
  end_date date
);

When I try to insert into the table, I get:

DEBUG tokio_postgres::prepare] preparing query s6: insert into data (id, offset, state, start_date, end_date) values ($1, $2, $3, $4,$5)
DEBUG tokio_postgres::query] executing statement s6 with parameters: ["48d0d7de-c249-4b7c-9215-e0de4ab02ea1", 0, "NA", "2007-01-04", "2013-01-03"]
Error: Error { kind: ToSql(1), cause: Some(WrongType { postgres: Int4, rust: "i64" }) }

I'm confused why I cannot insert this row. If I execute the same row in a pgadmin, or terminal, it seems fine.

Could someone please explain why I'm getting this issue?

[madelaney]

Sorry, wrong repo. Please ignore.