[BUGS] Cannot select from 'UPDATE RETURNING'

2007-09-12 Thread valgog
Hi, I am no sure if it is a bug at all, but according to the documented features of UPDATE I would suppose it is. UPDATE RETURNING clause cannot be used in SELECT * FROM ( query ) AS query_alias statement. For example: update issues set issue_value = 'value to assign' where id in ( ) returning

[BUGS] PL/TCL can make postgres become multithreaded

2007-09-12 Thread Marshall, Steve
This has already been posted to pgsql-patches, but perhaps it belongs better here... There is a problem in PL/TCL that can cause the postgres backend to become multithreaded. Postgres is not designed to be multithreaded, so this causes downstream errors in signal handling. We have seen this cau