Insert and Upsert do not work

[princefishthrower]

Bug report

Describe the bug

As the title states, Insert and Upsert do not work - they fail to create and/or update records respectively.

To Reproduce

Try to call Insert or Upsert on any postgres table using supabase-go. I've tried the following combinations:

s.Client.From("my_table").Insert(bytes, true, "", "minimal", "exact").Execute()
s.Client.From("my_table").Insert(bytes, false, "", "minimal", "exact").Execute()
s.Client.From("my_table").Insert(bytes, true, "", "representation", "exact").Execute()
s.Client.From("my_table").Insert(bytes, false, "", "representation", "exact").Execute()
s.Client.From("my_table").Upsert(bytes, "", "representation", "exact").Execute()
s.Client.From("my_table").Upsert(bytes, "", "minimal", "exact").Execute()
s.Client.From("my_table").Upsert(bytes, "my_primary_key_column", "representation", "exact").Execute()
s.Client.From("my_table").Upsert(bytes, "my_primary_key_column", "minimal", "exact").Execute()

I've tried for when the row exists and when it does not; Upsert and Insert fail to update or create the record respectively. The strangest thing is that no error is reported, and with "representation", I always get an empty array.

Expected behavior

The desired row should be inserted. In the case of already existing by primary key, upserted.

Screenshots

N/A

System information

• OS: macOS
• Go version 1.21.11

Additional context

I do notice there are no tests including Insert or Upsert, perhaps adding those would help be a cross check against this bug into the future.

[muratmirgun]

Thanks for the issue first of all!
I will check and send the result here asap!

[muratmirgun]

Which postgrest-go version did you use?

[dmedora]

Just noting that Insert works for me, like so:

rowJSON := map[string]string{"column1":"val1", "column2":"val2"}
client.From(mytable).Insert(rowJSON, false, "", "representation", "").Execute()

[ziggycross]

I'm also having a lot of trouble getting the examples to work. Some tests that show how this is meant to be done would be much appreciated!

[kiwicopple]

I can imagine this is related to Postgres Row Level Security - if you have RLS enabled (which you should) make sure you have some policies to allow SELECT/INSERT/UPDATE