supabase-community / postgrest-csharp

A C# Client library for Postgrest
https://supabase-community.github.io/postgrest-csharp/api/Postgrest.html
MIT License
114 stars 22 forks source link

Bulk Insert and Upsert don't work #36

Closed warflash closed 2 years ago

warflash commented 2 years ago

Bug Report

Describe the bug

Bulk inserts and upserts currently don't seem to work. The column thats labeled as primary key is inserted successfully, all other columns get set to zero values.

Reproduction

Unfortunately I'm not sure how to setup the tests locally so I couldn't go and debug myself. Though I setup a minimal example with two columns in supabase and it did not work. Screenshot: image

System Info

acupofjose commented 2 years ago

@warflash thanks for the detailed issue! I was able to duplicate it pretty quickly and should have it resolved in postgrest-csharp@2.0.4. Please let me know if you see the problem persisting after updating to the latest version!

warflash commented 2 years ago

That fixed it indeed, thanks a lot for the quick response and update, much appreciated! I did stumble across something else while playing around, will open a new issue for that in a bit. Thanks again for the patch :)