From: | Cedar Cox <cedarc(at)visionforisrael(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Postgresql/Cold Fusion cfinsert date problems |
Date: | 2001-07-03 20:19:22 |
Message-ID: | Pine.LNX.4.21.0107032316290.11711-100000@nanu.visionforisrael.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)mail(dot)hartingdale(dot)com(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Haddon | 2001-07-04 02:31:09 | Re: Postgresql/Cold Fusion cfinsert date problems |
Previous Message | Tom Lane | 2001-07-03 14:31:17 | Re: Postgresql/Cold Fusion cfinsert date problems |