Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] 0x1A in control file on Windows

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: [HACKERS] 0x1A in control file on Windows
Date: 2008-09-18 11:02:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-hackers
ITAGAKI Takahiro wrote:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
>>> We probably need to add PG_BINARY when we open control files
>>> because 0x1A is an end-of-file marker on Windows.
>> Well, why is that a bug?  If the platform is so silly as to define text
>> files that way, who are we to argue?
> Google says it is for for backward compatibility with CP/M
> and adding O_BINARY is the answer.

Yes, apparently that's exactly why we have PG_BINARY, see c.h:

> /*
>  *	NOTE:  this is also used for opening text files.
>  *	WIN32 treats Control-Z as EOF in files opened in text mode.
>  *	Therefore, we open files in binary mode on Win32 so we can read
>  *	literal control-Z.	The other affect is that we see CRLF, but
>  *	that is OK because we can already handle those cleanly.
>  */
> #if defined(WIN32) || defined(__CYGWIN__)
> #define PG_BINARY_A "ab"
> #define PG_BINARY_R "rb"
> #define PG_BINARY_W "wb"
> #else
> #define PG_BINARY	0
> #define PG_BINARY_A "a"
> #define PG_BINARY_R "r"
> #define PG_BINARY_W "w"
> #endif

I don't see anything wrong with the patch, but I wonder if there's more 
open() calls that need the same treatment? Like the one in 

   Heikki Linnakangas

In response to


pgsql-hackers by date

Next:From: Bernt DrangeDate: 2008-09-18 11:13:08
Subject: Regaining superuser access
Previous:From: Heikki LinnakangasDate: 2008-09-18 10:56:11
Subject: Re: Adding new flags to XLogRecord

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2008-09-18 11:17:53
Subject: Re: [HACKERS] 0x1A in control file on Windows
Previous:From: Peter EisentrautDate: 2008-09-18 10:57:38
Subject: Re: BUG #4421: convert_to() should be immutable

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group