Gabriel
Gabriel
Could you build a docker image with this change so I can try this with postgres 15?
Suggested syntax change done! Also modified the column alias syntax "as contype" as it seems that this is always used for column alias.
Confirm is working nicely version v10.0.0!
> > > > Hi, i have similar problem on pg:latest (15) tag (docker) Upgrade postgrest to at least v10.0.0, this is not happening anymore, already solved.
I'm using the postgres 15 beta 2. I think that I found the query that fails, if I try to manually execute it it fails: Found here: https://github.com/PostgREST/postgrest/blob/bac63f339daa4a9292870b0674b41cde2bcfee74/src/PostgREST/DbStructure.hs#L655-L809 I'm trying...
The issue is here, but I don't quite understand why it fails, it is mixing char and text: 
Possible fix is to add a cast to the first union: 
Seems to be just that, contype is type "char" and concat returns type "text", so the union fails: 
Clossing this as this was corrected in v10.0.0! Thanks.
Hi, any news about this one? Final version is released