9.1 beta1 error

On 14 June 2011 05:17, Franklin Haut <franklin.haut@gmail.com> wrote:

hi people, postgresql goes down on a  WindowsXP SP3 machine.
there a script to reproduce. (on XP with 8.4 works fine)

CREATE DATABASE teste
  WITH OWNER = postgres
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       LC_COLLATE = 'Portuguese_Brazil.1252'
       LC_CTYPE = 'Portuguese_Brazil.1252'
       CONNECTION LIMIT = -1;

CREATE TABLE "public"."s230chr" ( "codemp" INTEGER, "codfil" INTEGER,
"codass" INTEGER,  "codseq" INTEGER, PRIMARY KEY("codemp", "codfil",
"codass", "codseq") ) WITH OIDS
ALTER TABLE "public"."s230chr" ADD COLUMN "ho1ser" TIME(0) WITHOUT TIME
ZONE;
ALTER TABLE "public"."s230chr" ADD COLUMN "ho2ser" TIME(0) WITHOUT TIME
ZONE;
ALTER TABLE "public"."s230chr" ADD COLUMN "ho3ser" TIME(0) WITHOUT TIME
ZONE;
ALTER TABLE "public"."s230chr" ADD COLUMN "ho4ser" TIME(0) WITHOUT TIME
ZONE;
ALTER TABLE "public"."s230chr" ADD COLUMN "cobhte" BOOLEAN;
INSERT into s230chr (codemp, codfil, codass, codseq, ho1ser, ho2ser) values
(1,1,1,1,'08:00', '11:00');
-- ERROR on next query
select
  sum( extract ( EPOCH FROM coalesce( (ho2ser - ho1ser), '00:00:00') +
                            coalesce( (ho4ser - ho3ser), '00:00:00') ) /
3600 ) as tthora
from s230chr where codemp = 1 and codfil = 1 and codass = 1 and cobhte IS
NULL

...and what's the error?

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Tue, Jun 14, 2011 at 1:17 AM, Franklin Haut <franklin.haut@gmail.com> wrote:

hi people, postgresql goes down on a  WindowsXP SP3 machine.
there a script to reproduce. (on XP with 8.4 works fine)

There is a crash related to time zone handling that was fixed in 9.1beta2.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Hass,

there problem are fixed in 9.1beta2, and now works.

thanks

2011/6/14 Robert Haas <robertmhaas@gmail.com>