Bug 17736

Summary: Postgres port should be updated to 7.0beta series, 6.5.3 has severe bugs that won't be fixed
Product: Ports & Packages Reporter: mjy <mjy>
Component: Individual Port(s)Assignee: andreas <andreas>
Status: Closed FIXED    
Severity: Affects Only Me    
Priority: Normal    
Version: Latest   
Hardware: Any   
OS: Any   

Description mjy 2000-04-01 22:20:01 UTC 
Postgres 6.5.3 contains bugs which won't be fixed according to the maintainers. For example,
the backend crashes with some aggregate queries on views. Example:

 create table a (x float, id text);
 create view b as select min(x),id from a group by id;
 insert into a values (0,'x');
 select a0.* from a a0, b b0 where b0.id=a0.id and a0.x=b0.min;

This bug has been fixed in 7.0beta3, but won't be fixed for 6.5.3 (development on that branch has ceased completely).
Because of this, and because the maintainers say: "No, the 6.5.* releases are done.  7.0 is in beta.  Many think
7.0beta* is more stable than the 6.5.* release." I'd like to suggest that 7.0beta should be used
for STABLE ports.
Comment 1 Akinori MUSHA freebsd_committer freebsd_triage 2000-04-16 15:11:57 UTC 
Responsible Changed
From-To: freebsd-ports->andreas

Over to MAINTAINER
Comment 2 andreas freebsd_committer freebsd_triage 2000-04-17 21:56:44 UTC 
State Changed
From-To: open->closed

committed port upgrade to postgresql 7.0 beta 5