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