Spaces_og's save() function uses an UPDATE query incompatible with postgresql (patch attached) [#592764]

When you update a features public/private status in an og space, the UPDATE query uses INNER JOINs that fail with Postgresql.

Comment	File	Size	Author
#1	spaces_save_og2x_update_public_1.patch	1.21 KB	halcyonCorsair
	spaces_save_og2x_update_public.patch	1.2 KB	halcyonCorsair

Comments

Comment #1

halcyonCorsair commented 1 October 2009 at 21:38

Status	File	Size
new	spaces_save_og2x_update_public_1.patch	1.21 KB

Oops, add {}'s around table names.

also is their a reason you changed the form of the query so much?
from joins to a subquery?
miccolis: postgres doesn't like INNER JOINs in update queries
miccolis: hmm, i think i can rewrite it to use a FROM instead of the subselect to be in a similar form, but i don't think that would work with mysql
Ok, subselect is fine.