>
> "id" is an int8. I didn't knew that it has to be quoted in order to be
> interpreted into something else than an int4.
IMO it's a good idea to quote all numerics regardless of type in postgres. as a side effect, it will allow the planer to make smarter choices for int8.