Re: 9.1 beta1 error

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
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2011-06-14 08:16:27 Re: ECPG parse.pl and parse2.pl
Previous Message Dave Page 2011-06-14 06:58:55 Re: FOREIGN TABLE doc fix