Re: Postgresql/Cold Fusion cfinsert date problems

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
>