Re: BUG #12950: Update problem

On Thursday, April 2, 2015, <robert(dot)uradin(at)gmail(dot)com> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 12950
> Logged by: Robert
> Email address: robert(dot)uradin(at)gmail(dot)com <javascript:;>
> PostgreSQL version: 9.3.6
> Operating system: Win 7
> Description:
>
> not executing like none UPDATE command, colleagues with the same username
> and password entered and executed from another computer without any
> problem,
> can you help me what is the problem, thanks!
>
>
> error:
>
> ERROR: syntax error at or near "set"
> LINE 1: SELECT COUNT(*) AS total FROM (UPDATE belot_user set permane...
> ^
> In statement:
> SELECT COUNT(*) AS total FROM (UPDATE belot_user set permanent_ban=1 where
> fb_last_used_name='Robert Uradin') AS sub
>
>
If you put the UPDATE in a WITH (cte) and add a RETURNING you can make this
work. If your colleague got this to work as written, on PostgreSQL, you
shoud probably ask them what you are doing wrong/different. The update,
especially without returning, is not a valid relation so cannot be placed
in the FROM clause. I'm somewhat surprised the parser made it to the word
set before choking as I would have thought the update would be
rejected...but unlike the sql standard Postgresql has managed to leave
update unreserved.

David J.