Labkey.Query.insertRows throws null value exception for primary key

LabKey Support Forum (Inactive)
Labkey.Query.insertRows throws null value exception for primary key Maya Li  2011-11-28 23:33
Status: Closed
 
Thanks, Matt. I will try to use those column elements if this happens again for a quicker fix (I had to rebuild my schema this time, unfortunately.) . I did try setting IsAutoInc, which did not solve the issue.

Ben, I am sorry that I must have confused you. The SQL script that I included in my first message was from my PgAdmin, which added "not null" automatically since m_requirementid is defined as a primary key. If you would be willing to try the example again, leaving the "not null" out for m_requirementid, you may be able to replicate my problem. I will look out for AI in the schema browser next time. I believe I did see it but I cannot confirm.

Thanks again for your responses.