Postgresql primary key not auto incrementing even when notation serial specified using .net core

Question

Postgresql primary key not auto incrementing even when notation serial specified this is my table create script

CREATE TABLE public."Medication" (
    "Id" serial NOT NULL,
    "ResidentId" int4 NOT NULL,
    "PharmacyId" int4 NULL,
    "PhysicianId" int4 NULL,
    "ReleasedQty" float8 NOT NULL DEFAULT '0'::double precision,
    "PRNEffectiveTime" int4 NULL,
    "IsSTO" bool NOT NULL DEFAULT false,
    "IsPendingOrder" bool NOT NULL DEFAULT false,
    "IsPsychotropic" bool NOT NULL DEFAULT false,
    "IsINRRequired" bool NOT NULL DEFAULT false,
    "eSignature" varchar NULL,
    "eSignatureDate" timestamp NULL,
    "PhysicianId_X" int4 NULL,
    "IsWitnessSigReq" bool NULL,
    "IsInjection" bool NULL,
    "AdministerByRole" varchar NULL,
    "AdministerByUser" varchar NULL,
    "AlfId" int4 NOT NULL,
    CONSTRAINT "Medication_pkey" PRIMARY KEY ("Id", "AlfId")
)
PARTITION BY RANGE ("AlfId");

the value of Id always remains zero

Then you are apparently explicitly inserting 0 into that column. — user330315
– user330315, Commented Oct 21, 2020 at 9:54
Unrelated to your problem, but: you should really avoid those dreaded quoted identifiers. They are much more trouble than they are worth it. wiki.postgresql.org/wiki/… — user330315
– user330315, Commented Oct 21, 2020 at 9:54
I am using .net core to insert data and then it is happening — Ali Hussain
– Ali Hussain, Commented Oct 21, 2020 at 9:55

Ali Hussain · Accepted Answer · 2020-10-21 10:06:25Z

2

My query was inserting explicit value 0 and this was happening in .net core with Medication Object containing Id zero. when in my class I specified Id as Identity column then it fixed

Table("Medication")]
    public partial class Medication
    {
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }

I was not adding [DatabaseGenerated(DatabaseGeneratedOption.Identity)] and this is why it was happening

answered Oct 21, 2020 at 10:06

Ali Hussain

95615 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql primary key not auto incrementing even when notation serial specified using .net core

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related