Re: [BUGS] Subquery with toplevel reference used to work in pg 8.4

2012-03-24 Thread Tom Lane
Mark Murawski writes: > I agree the query is a little odd, but I like backwards compatibility! AFAICT, 8.4 is broken too --- did you try any cases where the WHERE-condition should filter rows? I created this similar test case using the regression database: select * from int8_tbl t1 left join

Re: [BUGS] check_locale() and the empty string

2012-03-24 Thread Tom Lane
Jeff Davis writes: > The following SQL succeeds: > create database foodb with > template = template0 > encoding = 'UTF8' > lc_collate='' > lc_ctype=''; Sure. > Surely we don't want it to be set from the environment, right? Why not? We have always done that, and in fact the va