Re: [HACKERS] 9.1 beta1 error
On 14 June 2011 05:17, 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) 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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] 9.1 beta1 error
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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] 9.1 beta1 error
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
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