Re: time zone setting.

From: Kris Jurka <books(at)ejurka(dot)com>
To: dexdyne <from_postgresql_forum(at)dexdyne(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: time zone setting.
Date: 2011-08-30 17:21:35
Message-ID: alpine.BSO.2.00.1108301249310.10923@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tue, 30 Aug 2011, dexdyne wrote:

> Well I know I tried it and I know it barfed.
>

I think your problem is that not all postgresql commands can take
parameters. For example you cannot do "SET TIMEZONE = ?" with a prepared
statement. Instead you can do "SELECT set_config('timezone', ?,
true/false)" with a prepared statement.

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message dexdyne 2011-08-31 09:36:45 Re: time zone setting.
Previous Message dexdyne 2011-08-30 09:51:25 Re: time zone setting.