Re: BUG #13148: Unexpected deferred EXCLUDE constraint violation on derived table

On Sun, May 10, 2015 at 11:28 AM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> Please don't top-post.
>
> On Sun, May 10, 2015 at 11:19 AM, <postgresql2(at)realityexists(dot)net> wrote:
>
>> That's odd! I just confirmed again that I get the exact same error with
>> COMMIT (and no warnings). Are you able to run all the commands before the
>> COMMIT successfully and get 1 row back from the SELECT?
>>
>>
> ​I am. I am not using psql so I may be getting different errors compared
> to what psql would eventually emit. I suspect that the actual error is
> getting swallowed somewhere and then the processing on the COMMIT happens
> without the transaction being open.
>

​To clarify - the transaction still errors out; but to me, not using psql,
it seems to do so prior ​to the COMMIT itself being processed and so the
commit emits a warning about not being in a tranasction.

Ubuntu apt.postgresql.org 9.3.5

David J.