9.1 beta1 error

From: Franklin Haut <franklin(dot)haut(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: 9.1 beta1 error
Date: 2011-06-14 05:17:41
Message-ID: BANLkTimmsmgzEBryVnUWw2CVXmvHnTOuCw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jun Ishiduka 2011-06-14 06:03:47 Online base backup from the hot-standby
Previous Message Tom Lane 2011-06-14 05:15:20 Re: pg_trgm: unicode string not working