> postgresql process crashes on select * from cmd_sm (which is a view)
Poking into this revealed what seems to be a long-standing bug: a view
that uses BETWEEN gets confused about any variables appearing in the
first argument of the BETWEEN. I've fixed this in current sources,
but for 7.0.* you'd be best advised to write out BETWEEN explicitly
as "a >= b AND a <= c".
A separate issue is that grouped views don't work very well in 7.0.*.
This is also fixed for 7.1, but in the meantime don't expect to be able
to apply aggregates or grouping to the output of a grouped view.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Chris||Date: 2000-12-21 18:31:50|
|Subject: Re: Problem with apostrophes in TK frontend|
|Previous:||From: pgsql-bugs||Date: 2000-12-21 17:14:38|
|Subject: Problem with apostrophes in TK frontend|