Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13891: Deparsed arbiter WHERE clauses cannot be parsed by Postgres - Mailing list pgsql-bugs

From Önder Kalacı
Subject Re: BUG #13891: Deparsed arbiter WHERE clauses cannot be parsed by Postgres
Date
Msg-id CACawEhW1nBgeNn1r3hGgdyrJjbmaprrSGJdcQFpL-+Wj5C6JxA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #13891: Deparsed arbiter WHERE clauses cannot be parsed by Postgres  (Peter Geoghegan <pg@heroku.com>)
Responses Re: BUG #13891: Deparsed arbiter WHERE clauses cannot be parsed by Postgres
List pgsql-bugs
Tree view
Hi Peter,

Thanks for the quick response.


I'm curious: How did you find this bug? Did you just stumble upon it?

We use postgres' ruleutils.c to build SQL strings. I realized this while I was playing with UPSERTs on 9.5.

Does the rewritten query actually error? In other words, is your
complaint strictly that deparsing is broken?

Yes, the rewritten query actually errors and our complaint is that a deparsed query cannot be parsed by postgres again.

Thanks

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #13892: SELECT FALSE = FALSE = TRUE; error
Next
From: ssudnik@gmail.com
Date:
Subject: BUG #13894: MANPATH in documentation - wrong path