From owner-freebsd-ports  Sat Apr  1 13:20:11 2000
Delivered-To: freebsd-ports@freebsd.org
Received: from freefall.freebsd.org (freefall.FreeBSD.ORG [204.216.27.21])
	by hub.freebsd.org (Postfix) with ESMTP id 3056437BC90
	for <freebsd-ports@FreeBSD.org>; Sat,  1 Apr 2000 13:20:02 -0800 (PST)
	(envelope-from gnats@FreeBSD.org)
Received: (from gnats@localhost)
	by freefall.freebsd.org (8.9.3/8.9.2) id NAA84123;
	Sat, 1 Apr 2000 13:20:02 -0800 (PST)
	(envelope-from gnats@FreeBSD.org)
Received: from freefall.freebsd.org (freefall.FreeBSD.ORG [204.216.27.21])
	by hub.freebsd.org (Postfix) with ESMTP id D344837B676
	for <freebsd-gnats-submit@FreeBSD.org>; Sat,  1 Apr 2000 13:18:39 -0800 (PST)
	(envelope-from nobody@FreeBSD.org)
Received: (from nobody@localhost)
	by freefall.freebsd.org (8.9.3/8.9.2) id NAA83534;
	Sat, 1 Apr 2000 13:18:39 -0800 (PST)
	(envelope-from nobody@FreeBSD.org)
Message-Id: <200004012118.NAA83534@freefall.freebsd.org>
Date: Sat, 1 Apr 2000 13:18:39 -0800 (PST)
From: mjy@pobox.com
To: freebsd-gnats-submit@FreeBSD.org
X-Send-Pr-Version: www-1.0
Subject: ports/17736: Postgres port should be updated to 7.0beta series, 6.5.3 has severe bugs that won't be fixed
Sender: owner-freebsd-ports@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.org


>Number:         17736
>Category:       ports
>Synopsis:       Postgres port should be updated to 7.0beta series, 6.5.3 has severe bugs that won't be fixed
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-ports
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Sat Apr  1 13:20:01 PST 2000
>Closed-Date:
>Last-Modified:
>Originator:     Marinos J. Yannikos
>Release:        4.0-RELEASE
>Organization:
>Environment:
FreeBSD k7 4.0-RELEASE FreeBSD 4.0-RELEASE #0: Sat Apr  1 21:49:14 GMT 2000     root@k7:/usr/src/sys/compile/c0w40  i386
>Description:
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.

>How-To-Repeat:

>Fix:


>Release-Note:
>Audit-Trail:
>Unformatted:


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-ports" in the body of the message