On Sun, Sep 11, 2005 at 12:43:58AM -0400, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > Apparently the two intervals don't cancel each other out (i.e.,
> > they're not optimized to zero),
>
> Well, no, because + and - associate left-to-right.
Sure, I wasn't expecting any differen
Michael Fuhr <[EMAIL PROTECTED]> writes:
> Apparently the two intervals don't cancel each other out (i.e.,
> they're not optimized to zero),
Well, no, because + and - associate left-to-right.
> so effectively we get this:
> test=> select '2005-08-31'::date + '1 month'::interval;
> ?column?
On Fri, Sep 09, 2005 at 08:54:05AM +0100, Sijin MS wrote:
> We are a Software Provider and promoting Linux. Most of our clients are
> using Linux. We are using postgres v7.3.2-3 as a backend for our application
> software. While inserting data into table, we found that sometime the data
> is not in
On Fri, Sep 09, 2005 at 01:00:31PM +0100, [EMAIL PROTECTED] wrote:
> select '2005-08-31'::date + '1 month'::interval-'1 month'::interval
>
> from the mathematical me the resulting value should be '2005-08-31'
You didn't show any output; this is what I get:
test=> select '2005-08-31'::date + '1 m
Arjen van der Meijden <[EMAIL PROTECTED]> writes:
> In the postgresql.log a write-failure messages was repeated enough to
> make the log file 50MB larger:
> [ - 2005-09-07 13:03:47 CEST @] ERROR: xlog flush request 29/67713428
> is not satisfied --- flushed only to 29/2E73E488
> [ - 2005-09-07
Bob Friesenhahn <[EMAIL PROTECTED]> writes:
> Ugh. I do think that readline 5.0 itself has a minor bug in that ldd
> on libreadline.so does not show a dependency on the curses library,
> even though it is obviously required. This means that the linkage of
> libreadline.so is incomplete.
That'
On Sat, Sep 10, 2005 at 05:46:44PM +0100, Byron wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1875
> Logged by: Byron
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 8.0.3
> Operating system: Windows XP
> Description:Function paramet
Mark Diener wrote:
> It seems the EXECUTE privilege is not the only privilege that is
> being checked during the execution of a PL/psql procedure
> language/function.
The EXECUTE privilege is checked before the function is executed.
During the execution of a function, you still need for each ope
On Thu, 8 Sep 2005, Peter Eisentraut wrote:
Bob Friesenhahn wrote:
The config.log and a build log are attached.
It's puzzling why the test program compiles and links without complaint
when the isinf() function does not exist. Can you try to isolate the
test program from configure and see wha
The following bug has been logged online:
Bug reference: 1875
Logged by: Byron
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Windows XP
Description:Function parameter names clash with table column names
Details:
---
The following bug has been logged online:
Bug reference: 1867
Logged by: Dave Goertz
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.5
Operating system: Windows XP Professional(Client)
Description:ODBC dirver Problem
Details:
When using ODBC version 07_03_0
The following bug has been logged online:
Bug reference: 1870
Logged by: Sijin MS
Email address: [EMAIL PROTECTED]
PostgreSQL version: v7.3.2-3
Operating system: Redhat 9
Description:Insertion problem
Details:
Dear Sir or Madam:
We are a Software Provider and promo
The following bug has been logged online:
Bug reference: 1868
Logged by: Karim Mardhani
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Windows 2000 service pack 4
Description:Initdb error during silent install on windows 2000
Details:
I
The following bug has been logged online:
Bug reference: 1874
Logged by: Mark Diener
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.03
Operating system: linux-i686
Description:Non-Execute Privileges enforced on grant
Details:
It seems the EXECUTE privilege i
The following bug has been logged online:
Bug reference: 1873
Logged by: Lee Benson
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: Windows XP Pressional
Description:"Invalid username specified" during install
Details:
I am trying to rei
The following bug has been logged online:
Bug reference: 1872
Logged by: Hugo Cesar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1, 8.2 and8.3
Operating system: Win2000 Server and Win2000 Pro
Description:Failed to create process: 2!
Details:
This error app
Hi
I have the next error
Failed to create process: 2!
with Windows2000 Professional and Windows2000 Server
with installer PostgreSQL 8.0.1, 8.0.2 and 8.0.3
Thanks!
---(end of broadcast)---
TIP 5: don't forget to increase your free space ma
Hi list,
I noticed a development machine was responding terribly slow, and found
out postgresql had consumed all available memory:
USER PID %CPU %MEMVSZ RSS TTY STAT START TIME COMMAND
postgres 7465 0.0 0.0 16636 928 ?SSep05 0:00
/usr/bin/postmaster -D /
The following bug has been logged online:
Bug reference: 1871
Logged by:
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7-8
Operating system: Linux
Description:operations with data types
Details:
May be it is not bug, but anywhere:
here you are sample query
19 matches
Mail list logo
