Please, take a look at my implementation of stat().
It has at least two advantages: it's faster and doesn't have a bug with
local-to-UTC time conversion that native msvc's stat() has.
Maybe it will be useful.
From: Magnus Hagander [mailto:magnus(at)hagander(dot)net]
Sent: Tuesday, April 29, 2008 4:54 PM
To: Zubkovsky, Sergey
Cc: Andrew Dunstan; Tom Lane; Alvaro Herrera; Gregory Stark;
Subject: Re: [HACKERS] [DOCS] pg_total_relation_size() and CHECKPOINT
I already applied a different patch for this quite some time ago. So
what's in HEAD (and current in 8.3 and 8.2) should be fixed already.
Zubkovsky, Sergey wrote:
> Here is the patch.
> Check it, please.
> Locations of the added files:
> Thank you.
> -----Original Message-----
> From: Andrew Dunstan [mailto:andrew(at)dunslane(dot)net]
> Sent: Saturday, March 29, 2008 4:18 PM
> To: Zubkovsky, Sergey
> Cc: Tom Lane; Alvaro Herrera; Gregory Stark;
> pgsql-hackers(at)postgresql(dot)org; Magnus Hagander
> Subject: Re: [HACKERS] [DOCS] pg_total_relation_size() and CHECKPOINT
> Zubkovsky, Sergey wrote:
>> In the prepared custom build of PG 8.3.1 the native MSVC's stat() was
> rewrote by adding GetFileAttributesEx() to correct stat's st_size
>> I had seen that a result of MSVC's stat() and a result of
> GetFileAttributesEx() may be differ by the file size values at least.
>> The most important thing is the test in the original post
>> ( http://archives.postgresql.org/pgsql-docs/2008-03/msg00041.php )
>> doesn't reproduce any inconsistence now.
>> All work fine.
>> This was tested on my WinXP SP2 platform but I suppose it will work
> any NT-based OS.
> If you have a patch, please send it to the -patches list.
In response to
pgsql-hackers by date
|Next:||From: Peter Eisentraut||Date: 2008-04-29 17:11:10|
|Subject: Re: Proposed patch - psql wraps at window width|
|Previous:||From: Aidan Van Dyk||Date: 2008-04-29 15:23:04|
|Subject: Re: Protection from SQL injection|
pgsql-patches by date
|Next:||From: Alex Hunsaker||Date: 2008-04-29 17:48:14|
|Subject: Re: [firstname.lastname@example.org: Re: [BUGS] Problem identifying constraints which should not be inherited]|
|Previous:||From: Alvaro Herrera||Date: 2008-04-29 14:06:28|
|Subject: Re: [HACKERS] Proposed patch - psql wraps at window width|