Re: [BUGS] Bug #536: the sql 'except' generates erroneous result

2001-12-11 Thread Tom Lane
[EMAIL PROTECTED] writes: > the sql 'except' generates erroneous result Yeah, anything with nested intersect/except is likely to give the wrong answers in 7.1.* :-(. This seems to be a variant of that problem. In 7.2beta I get the expected answer: regression=# select distinct t.studid from stra

[BUGS] Bug #536: the sql 'except' generates erroneous result

2001-12-11 Thread pgsql-bugs
luby liao ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description the sql 'except' generates erroneous result Long Description A student of mine, Sean Canaday, worked on prob 6.17 of M Kifer's Dabatabase book (AW, p175): 6.17 Consider

[BUGS] Pgsql question

2001-12-11 Thread Ken Mathieu
Hi there,     First i must say that iv started using pgsql recently(on a linux redhat apache server with mod perl "DBI").  I have this problem after a little while there is too many pgsql process hanging "idle" and when we try to connect the server say: psql: Sorry, too many clients already