PostgreSQL Bugs - Re: field-update in before-trigger causes distinct to 'fail', new in v8.1 versus v8.0.4, demo-sql i

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: field-update in before-trigger causes distinct to 'fail', new in v8.1 versus v8.0.4, demo-sql i

Tom Lane

2005-11-14, 1:24 pm

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Sponsored Links