`update().select().limit(1).single()` behavior not consistent

Hi we have two supabase projects. One's on postgres v15.1.1.73, the other is on v17.4.1.069.

on the v17, this works, on v15 it doesn't

 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .limit(1)
    .single();

 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .limit(1)
    .single();

to get it to work on v15, we had to remove the limit(1)

 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .single();

 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .single();

Is this a postgrest version issue?

Supabase•6mo ago•

43 replies

ytomtom

`update().select().limit(1).single()` behavior not consistent

Hi we have two supabase projects. One's on postgres v15.1.1.73, the other is on v17.4.1.069.

on the v17, this works, on v15 it doesn't

 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .limit(1)
    .single();

 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .limit(1)
    .single();

to get it to work on v15, we had to remove the limit(1)

 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .single();

 await supabase
    .from('Table')
    .update({
      foo: true,
      bar: true,
      baz: true
    })
    .eq('id', userID)
    .select('*')
    .single();

Is this a postgrest version issue?

`update().select().limit(1).single()` behavior not consistent

Similar Threads

`update().select().limit(1).single()` behavior not consistent

Similar Threads

Similar Threads

Similar Threads