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 -- tks Franklin Haut