aoyogi kouhei writes:
>> You did not say what timezone setting you are using, but in some of them
>> this is not wrong.
> My timezone is Asia/Tokyo. utc_offset_interval is 09:00:00.
According to the Olson timezone database, Tokyo observed local mean
solar time until the end of 1887:
--- snip --
Thanks reply.
My timezone is Asia/Tokyo. utc_offset_interval is 09:00:00.
2009/9/13 Tom Lane
> "Aoyai Kouhei" writes:
> > select '0001-01-01'::timestamp with time zone;
> > -> "0001-01-01 00:00:00+09:18:59"
>
> > select '1887-01-01'::timestamp with time zone;
> > -> "1887-01-01 00:00:00+09:18:5
Tatsuhito Kasahara wrote:
> dblink generates orphaned connections when we failed on performing dblink()
> function.
> # But it occurs only when dblink('conn_str', 'sql', true). See following
> examples.
> I think that the dblink should not ereport() before PQfinish(conn) in
> dblink_record_inter
The following bug has been logged online:
Bug reference: 5051
Logged by: the6campbells
Email address: the6campbe...@gmail.com
PostgreSQL version: 8.4.1
Operating system: windows
Description:SQLNumResultCols returns 0 for common table expression
Details:
"PostgreSQL
"Aoyai Kouhei" writes:
> select '0001-01-01'::timestamp with time zone;
> -> "0001-01-01 00:00:00+09:18:59"
> select '1887-01-01'::timestamp with time zone;
> -> "1887-01-01 00:00:00+09:18:59"
You did not say what timezone setting you are using, but in some of them
this is not wrong.
The following bug has been logged online:
Bug reference: 5050
Logged by: Aoyai Kouhei
Email address: aoyagi.kou...@gmail.com
PostgreSQL version: 8.4.1
Operating system: MacOS 10.6.1
Description:text to timestamp failure
Details:
select '0001-01-01'::timestamp with t
