I wrote:
> I was under the impression that there was some code in there to complain
> if the path-finding code failed, but maybe it's being executed too late.
I looked at this a bit more, and found that there is no such code.
Mark's complaint is easy to reproduce if you move (or hardlink) the
post
I wrote:
> With enough nines, the fsec value is going to round up to 1.0 (float
> case) or USECS_PER_SEC (int case). So I think that this check ought
> to allow, not exclude, the boundary value.
Patch applied here:
http://archives.postgresql.org/message-id/20090501192913.c39ec754...@cvs.postgresq
"Kruus, Robert ENV" writes:
>> Hmph. Is your installation built with --enable-integer-datetimes?
> Yes it is 'on'.
On further probing, I can make it happen with float datetimes too,
if I throw enough fractional nines in there:
regression=# select '1999-08-06
00:12:57.9
>>> Tom Lane wrote:
> but I bet it's the change in the default integer_datetimes setting
> that is the relevant difference.
Confirmed.
cc=> select '1999-08-06 00:12:57.99900Z'::timestamptz;
ERROR: date/time field value out of range: "1999-08-06
00:12:57.99900Z"
cc=> select version();
"Robert Kruuus" writes:
> More generally, even
> SELECT '1999-08-06 00:12:57.999Z'::timestamp with time zone; will throw
> the same error, so it seems to be something in the way Postgres
> rounds/truncates the field.
Hmph. Is your installation built with --enable-integer-datetimes?
(Try "sh
The following bug has been logged online:
Bug reference: 4789
Logged by: Robert Kruuus
Email address: robert.kr...@gov.sk.ca
PostgreSQL version: 8.3.7
Operating system: [FREEBSD] amd64-portbld-freebsd7.1, compiled by GCC cc
(GCC) 4.2.1
Description:ERROR 22008 on times
On Apr 26, 2:08 pm, dp...@pgadmin.org (Dave Page) wrote:
> On Fri, Apr 24, 2009 at 3:09 PM, Kevin Field
> wrote:
> > On Apr 24, 9:32 am, dp...@pgadmin.org (Dave Page) wrote:
>
> >> I don't know if there is any way we can solve it, except by reverting
> >> back to 5.8 or advising users to use only
Mark writes:
> As for pg_ctl assuming it can find postgres in the same directory it is
> in, it SHOULD. :) Basically, I hard-linked all files in
> /usr/local/PostgreSQL/bin/ to /usr/local/bin/. So, even when pg_ctl got
> started from /usr/local/bin/, it should have found /usr/local/bin/postgres
>
-Original Message-
From: pgsql-bugs-ow...@postgresql.org
[mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: vrijdag 1 mei 2009 17:46
To: Mark Kramer
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4787: Hardlink (ln) causes startup failure with
bizarre "timezone_abb
"Mark Kramer" writes:
> I have my PostgreSQL installed in /usr/local/PostgreSQL/ (cleaner for
> updates, instead of just /usr/local) As a result, I made hard-links like
> this,
> cd /usr/local/bin/
> ln /usr/local/PostgreSQL/bin/pg_ctl pg_ctl
This isn't going to work because pg_ctl assumes it ca
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: vrijdag 1 mei 2009 16:37
To: Craig Ringer
Cc: Mark; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Unable to make DBD-Pg-2.13.1
Craig Ringer writes:
>> Mark wrote:
>>> Until I tried to install DBD-Pg-2.13.1 (for Perl) th
>>> CK Leung wrote:
> the result : select * from tt order by item_code;
>
> item_code
> --
> V
> .V
> V.
> VA.AAA
> V.B
> V
> (V
> (V)
> (V)B.BBB
> (VB)BBB
> V.
> V)
> VCCC
> (13 rows)
>
> the sort sequence like ignore t
Craig Ringer writes:
> Mark wrote:
>> Until I tried to install DBD-Pg-2.13.1 (for Perl) thereafter. And I'm
>> getting the weirdest errors that just won't go away (see below). Does
>> anyone know what the cause might be? Or better still, how to fix it? :)
> Is it possible that you have old or con
Craig Ringer writes:
> sam rab wrote:
>> I tried to install postgresql 8.3.7 on Linux RedHat 7.2 platform.
>> [and got]
>> /usr/bin/ld:exports.list:1: parse error in VERSION script
> Your toolchain is just TOO OLD.
Yes. You could probably work around this particular issue by removing
the lin
Gerhard Kirchmann wrote:
The following bug has been logged online:
Bug reference: 4788
Logged by: Gerhard Kirchmann
Email address: gerhard.kirchm...@arcor.de
PostgreSQL version: 8.4beta1
Operating system: openSUSE 11.1
Description:bug in string comparison
Details:
The following bug has been logged online:
Bug reference: 4788
Logged by: Gerhard Kirchmann
Email address: gerhard.kirchm...@arcor.de
PostgreSQL version: 8.4beta1
Operating system: openSUSE 11.1
Description:bug in string comparison
Details:
I have the same table in 8
Mark wrote:
> I'm new to PostgreSQL. Just installed the latest version, 8.3.7, on my
> FreeBSD system (client + server). All went well...
>
> Until I tried to install DBD-Pg-2.13.1 (for Perl) thereafter. And I'm
> getting the weirdest errors that just won't go away (see below). Does
> anyone know
sam rab wrote:
> Great day to you!
> I tried to install postgresql 8.3.7 on Linux RedHat 7.2 platform.
Maybe this is a stupid question, but ... why?
Red Hat 7.2 is *ANCIENT*. There haven't been security updates since
nigh-unto-forever. It's using C libraries with a completely different
threa
I found some problem about the sorting when i switch to pg version 8.3.4
Table name : tt,
record list :
item_code
--
V
V
VCCC
(V)
V.
V.B
V.
.V
VA.AAA
(V
V)
(V)B.BBB
(VB)BBB
(13 rows)
the result : select * from tt order by item_code;
The following bug has been logged online:
Bug reference: 4786
Logged by: Pablo M. Ronchi
Email address: pmron...@yahoo.com.ar
PostgreSQL version: 8.3.x
Operating system: Windows XP 32bit
Description:Solution for: PostgreSQL server did not start (NET
HELPMSG 3534)
Deta
The following bug has been logged online:
Bug reference: 4787
Logged by: Mark Kramer
Email address: r...@asarian-host.net
PostgreSQL version: 8.3.7
Operating system: FreeBSD 7.1
Description:Hardlink (ln) causes startup failure with bizarre
"timezone_abbreviations" err
Great day to you!
I tried to install postgresql 8.3.7 on Linux RedHat 7.2 platform.
Process of "configure" ends normally,
process of "gmake" ends with this output of errors:
{
gmake[3]: Entering directory
`/usr/home/install/postgresql-8.3.7/src/interfaces/
libpq'
gcc -O2 -Wall -Wmis
On Wed, Apr 29, 2009 at 2:49 AM, Roger Krimstock wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4785
> Logged by: Roger Krimstock
> Email address: ...@avaya.com
> PostgreSQL version: 8.3.7-1
> Operating system: Windows XP
> Description: Installa
I'm new to PostgreSQL. Just installed the latest version, 8.3.7, on my
FreeBSD system (client + server). All went well...
Until I tried to install DBD-Pg-2.13.1 (for Perl) thereafter. And I'm
getting the weirdest errors that just won't go away (see below). Does
anyone know what the cause might be
Hi , I am with a problem ...
I need to download the postgresql version 8.3.4 , but all links are down !
how can you help me with that ?
Thanks !
Gustavo Guatimosim.
25 matches
Mail list logo
