[Haskell-cafe] HookedBuildInfo and Cabal

[John Goerzen]

Hi Brian & everyone,

Got this bug report, which appears to be related to your autoconf
patch.  Did you test it on Windows?

As a more general question, how can one use Cabal to detect PostgreSQL
paths in a way that works with both GHC 6.8 and 6.10?

The commit here was:

commit 57c723873b020643b9062941a2ece130cd0f36c6
Author: Brian Bloniarz <phunge0 at hotmail.com>
Date:   Fri Dec 26 14:33:43 2008 -0500

    Update hdbc-postgresql for GHC 6.10 & Cabal 1.6. This switches
    over to use autoconf rathe
r than Cabal hooks to detect postgres paths; there's no
    backwards-compatible way to use write
HookedBuildInfo with Cabal 1.2 and Cabal 1.6 (see
    http://www.haskell.org/pipermail/glasgow-ha
skell-users/2008-October/015707.html)

-- John

----- Forwarded message from software-noreply at complete.org -----

From: software-noreply at complete.org
Date: Thu, 08 Jan 2009 12:37:12 -0600
Subject: [HDBC PostgreSQL driver - Bug #131] Throw exception when use data type "timpstamp
	without time zone"

Issue #131 has been updated by Benjamin Cao.


by the way, I cannot configure 1.1.6.0.0 successfully on my windows OS because of the Expr command(which is a linux command, even if I got a windows version of it, it keep crash on windows.) The function isFixedPointUnderConversionToLocalTime in 1.1.6.0.0 is the same. So I think it should be a same issue on 1.1.6.0.0
----------------------------------------
Bug #131: Throw exception when use data type "timpstamp without time zone"
http://software.complete.org/software/issues/show/131

Author: Benjamin Cao
Status: New
Priority: Normal
Assigned to: 
Category: 
Target version: 1.1.4.1.0
Resolution: 


The database is like
CREATE TABLE test
(
  "name" character varying(200) NOT NULL,
  "time" timestamp with time zone,
  timenotz timestamp without time zone,
  CONSTRAINT test_pkey PRIMARY KEY (name)
)
WITH (OIDS=FALSE);
ALTER TABLE test OWNER TO postgres;

when call 
st <- prepare c "select name,time, timenotz  from test"
execute st []

Will get this error:
Time.toClockTime: timezone offset out of range

So I modified the function in statement.hsc to:
            isFixedPointUnderConversionToLocalTime calTime =
                do
                  let hasError = False
                  calTime' <- Control.Exception.catch 
                               (toLocalCalTime calTime) 
                               (\_->do let hasError = True
                                       return calTime)
                  if hasError 
                    then return False
                    else return $ eqParts calTime calTime'



----------------------------------------
You have received this notification because you have either subscribed to it, or are involved in it.
To change your notification preferences, please click here: http://software.complete.org/software/my/account

----- End forwarded message -----