Lists: | pgsql-hackers |
---|
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 |
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
From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Franklin Haut <franklin(dot)haut(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: 9.1 beta1 error |
Date: | 2011-06-14 07:45:32 |
Message-ID: | BANLkTinU=-Xn08riHU2w+PTkEEvyqOi+MQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 14 June 2011 05:17, Franklin Haut <franklin(dot)haut(at)gmail(dot)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
From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Franklin Haut <franklin(dot)haut(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: 9.1 beta1 error |
Date: | 2011-06-14 12:02:57 |
Message-ID: | BANLkTi=tC7TdAPycLauEDCfPAAQQxR8BTw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On Tue, Jun 14, 2011 at 1:17 AM, Franklin Haut <franklin(dot)haut(at)gmail(dot)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
From: | Franklin Haut <franklin(dot)haut(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: 9.1 beta1 error |
Date: | 2011-06-14 12:29:42 |
Message-ID: | BANLkTin+q_cpDscADA0pC=-gs=fRyw8a4A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hass,
there problem are fixed in 9.1beta2, and now works.
thanks
2011/6/14 Robert Haas <robertmhaas(at)gmail(dot)com>
> On Tue, Jun 14, 2011 at 1:17 AM, Franklin Haut <franklin(dot)haut(at)gmail(dot)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
>