Postgres Pro
Downloads
Home   >   mailing lists

Re: field-update in before-trigger causes distinct to 'fail', new in v8.1 versus v8.0.4, demo-sql included - Mailing list pgsql-bugs

From Tom Lane
Subject Re: field-update in before-trigger causes distinct to 'fail', new in v8.1 versus v8.0.4, demo-sql included
Date
Msg-id 23361.1131990286@sss.pgh.pa.us
Whole thread Raw
In response to field-update in before-trigger causes distinct to 'fail', new in v8.1 versus v8.0.4, demo-sql included  (Frank van Vugt <ftm.van.vugt@foxi.nl>)
List pgsql-bugs
Tree view 
Frank van Vugt <ftm.van.vugt@foxi.nl> writes:
> The following statement causes an error due to the fact that the distinct
> isn't producing distinct values anymore.
> This seems to be caused by the update of 'value' in the before-trigger.

Fix committed --- thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2040: buggy cast of INT8 to text
Next
From: Tom Lane
Date:
Subject: Re: field-update in before-trigger causes distinct to 'fail', new in v8.1 versus v8.0.4, demo-sql included