I am told that the backend to postgresql will automatically
timeout and close a JDBC client connection. In, addition
the client code in JDBC connection.isClosed() will wait
up to 30 seconds (SUN Java 1.3.1) to report the connection
being closed. I normally use Oracle and the server does not
automa
I got the following problem in PostgreSQL 7.1.3.
When I need to get next day relative to another one,
I do the following query:
SELECT date(date ? + interval '1 day').
But on '2001-10-28', I get this:
test=> SELECT date(date '2001-10-28' + interval '1 day');
date
2001-10-28
(1
try 'set timezone to ' replacing with your timezone
before your query.
template1=# set timezone to est;
SET VARIABLE
template1=# SELECT date(date '2001-10-28' + interval '1 day');
date
2001-10-29
(1 row)
-Original Message-
From: Fduch the Pravking [mailto:[EMAIL PROTEC
"Peter V. Cooper" <[EMAIL PROTECTED]> writes:
> I am told that the backend to postgresql will automatically
> timeout and close a JDBC client connection.
There is most certainly no such timeout in the backend. Who told
you that?
We do run TCP connections with SO_KEEPALIVE set, which will cause
On Thu, Jan 31, 2002 at 11:44:53AM -0500, Tom Pfau wrote:
> try 'set timezone to ' replacing with your timezone
> before your query.
>
> template1=# set timezone to est;
> SET VARIABLE
> template1=# SELECT date(date '2001-10-28' + interval '1 day');
> date
>
> 2001-10-29
> (1 r
I was told that by a reasonably proficient programmer who has
UNIX kernel level experience as do I. I am not trying to toot
mine or anyone's horn, merely trying to set the stage for a
reasonably technical discussion. It seems you know exactly
what I am talking about.
I make the assertion that a s
"Peter V. Cooper" <[EMAIL PROTECTED]> writes:
> I make the assertion that a servlet which has a connection open
> to the database at all times (a servlet/tomcat connection object)
> and is physically located on the same LAN as the database could
> easily have a Internet user connected remotely ste
This was just discussed yesterday on pgsql-novice, see
http://archives.postgresql.org/pgsql-novice/2002-01/msg00177.php
http://archives.postgresql.org/pgsql-novice/2002-01/msg00178.php
regards, tom lane
---(end of broadcast)
...
> Yes, it works!
> But now postgres accepts input and returns output
> in GMT, not local time like before! Is it a feature?
This strategy will not work in general unless you *do* set the time zone
to GMT (if it works at one boundary, say in the fall, then it will fail
at the other boundary in
Thomas Lockhart <[EMAIL PROTECTED]> writes:
> In the long run, we should probably implement some exact date/interval
> arithmetic instead of relying on timestamp types in the intermediate
> calculations.
AFAIK type "date" solves his problem just fine, and there's no need to
mess with timestamps a
>"Yan Bai" <[EMAIL PROTECTED]> writes:
> > I met a problem when i was loading data from a text file to the tables.
>
>You need to set DateStyle to tell the system the format of your date
>data before you load the file. Evidently the default (US style) is
>not what you are expecting.
Could you pl
Your name : Mike Riendeau
Your email address : [EMAIL PROTECTED]
System Configuration
-
Architecture (example: Intel Pentium) : Sun Sparc 20
Operating System (example: Linux 2.0.26 ELF) : Solaris 2.5.1
PostgreSQL version (example: PostgreSQ
"Riendeau, Mike" <[EMAIL PROTECTED]> writes:
> - psql is able to access the database created with createdb,
> but Seg Faults on exit.
> [ and various derivative problems ]
This has been reported before; IIRC the problem has to do with getting
your linkage to the readline shared library
> Could you please tell me how to set DateStyle? or where can I get the
> instruction about it?
In the reference page docs on your machine or at:
http://www.ca.postgresql.org/users-lounge/docs/7.1/reference/sql-set.html
I'm not sure I agree with every nuance of the recommendations for SET
DATES
14 matches
Mail list logo
