Re: [HACKERS] 9.1 beta1 error

[Franklin Haut]

Hass,

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


thanks


2011/6/14 Robert Haas robertmh...@gmail.com

 On Tue, Jun 14, 2011 at 1:17 AM, Franklin Haut franklin.h...@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

[HACKERS] 9.1 beta1 error

[Franklin Haut]

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