Visitar URL original
JsonPath column support · Issue #3044 · npgsql/efcore.pg · GitHub
Skip to content

JsonPath column support #3044

Closed

Description

@eknkc

Hi,

Is there a way to define a JsonPath column in ef core model? While doing this generates the correct migration and schema:

  [Column("filter_jsonpath", TypeName = "jsonpath")]
  [StringLength(4096)]
  public string? Filter_Jsonpath { get; set; }

It does not allow saving a jsonpath query in the database resulting the following exception:

PostgresException: 42804: column "filter_jsonpath" is of type jsonpath but expression is of type character varying

Can I somehow map a string to jsonpath in db?

Activity

  1. added a commit that references this issue on Oct 28, 2024
    699f588
  2. self-assigned this
    on Oct 28, 2024
  3. added this to the 9.0.0 milestone on Oct 28, 2024
  4. roji commented on Oct 28, 2024

    @roji
    Member

    Sorry for not answering earlier; I'm adding support for this for 9.0.

  5. added a commit that references this issue on Oct 28, 2024
    342c560
  6. added a commit that references this issue on Dec 18, 2024
    4be8d30
  7. added theissue type on Jun 19, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions