On Thu, 2010-02-11 at 23:39 +0900, Koichi Suzuki wrote:
> Dear Folks;
>
> A very serious bug was reported on pg_lesslog. So far, I found it's
> a bug in pg_compresslog. Please do not use pg_compresslog and
> pg_decompresslog until improved version is uploaded.
>
> I strongly advise to take ba
select '4714-01-27 BC'::date;
ERROR: date out of range: "4714-01-27 BC"
postgres=# select cast(test as date) from timetest;
test
---
4714-01-27 BC
(1 row)
postgres=#
postgres=# select cast('4714-01-27 BC' as date);
ERROR: date out of range: &
'4714-01-27 BC' as date);
> ERROR: date out of range: "4714-01-27 BC"
> postgres=#
>
> This seems pretty broken.
>
> Joshua D. Drake
And further this with timestamp instead of date:
postgres=# create table timestamptest(test timestamp);
CREATE TABLE
postgr
ows even have a concept of home directory?
Yes, from the shell it would be:
%HOMEDRIVE%
%HOMEPATH%
I believe.
Sincerely,
Joshua D. Drake
What would be a
reasonable equivalent to ~/.postgresql/ ?
regards, tom lane
---(end of broadcast)--
Original Message
Subject: [HACKERS] PostgreSQL ES3.0 problems?
Date: Wed, 24 Mar 2004 17:06:23 -0800
From: Joshua D. Drake <[EMAIL PROTECTED]>
Organization: Command Prompt, Inc.
To: [EMAIL PROTECTED]
Hello,
About a week ago we had a report of replicator not working cor
