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
There was a bug in 7.1.2 that was fixed in 7.1.3 that may be back in
7.2.
I downloaded 7.2 yesterday morning and started testing it. I left some
procedures running overnight performing random updates in a table.
Looking at task manager this morning, the three backend processes are
each consuming
No, that was a different problem related to recreating the
pg_internal.init file after a vacuum. This current leakage occurs
during normal usage.
-Original Message-
From: Henshall, Stuart - WCP
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 11:49 AM
To: 'Tom Lane'
nes are between 3 and 76 bytes.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 11:21 AM
To: Tom Pfau
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [BUGS] resource leak in 7.2
"Tom Pfau" <[EMAIL PROTECTED]> writes:
> There was a
the table with an update
simultaneously.
-Original Message-
From: Jason Tishler [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 05, 2002 3:03 PM
To: Tom Lane
Cc: Tom Pfau; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [CYGWIN] [BUGS] resource leak in 7.2
On Tue, Feb 05, 2002 at 01:07:1
SQL uses tri-state logic. If any value in an expression is unknown, the
answer is unknown. The only time you can get a true or false result
from an expression is if all values are known. In SQL, null represents
an unknown value - it does not represent an empty value (such as a zero
length strin
I don't fully understand the xlog files or WAL records but...
Why isn't the writing of the WAL record based on the CACHE value of the
sequence? If a request to nextval() can't be satisfied by the cache,
the sequence on disk should be updated resulting in a WAL record being
written.
If two sessi
Default parameters are filled in by the C++ compiler. You must provide
them when calling from a non-C++ program.
-Original Message-
From: Alban Médici [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 10:57 AM
To: plpgsql
Subject: [BUGS] Strange Behavior when calling a C function by
