Re: Postgresql/Cold Fusion cfinsert date problems - Mailing list pgsql-odbc

From Cedar Cox
Subject Re: Postgresql/Cold Fusion cfinsert date problems
Date
Msg-id Pine.LNX.4.21.0107032316290.11711-100000@nanu.visionforisrael.com
Whole thread Raw
In response to Re: Postgresql/Cold Fusion cfinsert date problems  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-odbc
On that note, where are the debug (-d) levels documented?  I couldn't find
it..  I had "query=4" in pg_options for v7.0.2.  What would that be in
v7.1?

Thanks,
-Cedar

On Tue, 3 Jul 2001, Tom Lane wrote:

> Paul Haddon <paullist@mail.hartingdale.com.au> writes:
> > The problem with this method is that the date that ends up in date
> > fields in the table is always the servers date, regardless of what
> > information is placed into the form field, and in what format.
>
> I don't know anything about Cold Fusion, but a good way to investigate
> what's going on would be to run the system with query tracing enabled
> (for an ODBC client, probably the only convenient way to do this is to
> start the postmaster with -d2, or the equivalent setting in
> postgresql.conf).  Then you could see exactly what queries are being
> issued by CF, which might give a clue what the problem is.
>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: RE: Postgresql/Cold Fusion cfinsert date problems
Next
From: BELLON Michel
Date:
Subject: odbc with MS-Query