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