Re: insert throw error when year field len > 4 for timestamptz datatype - Mailing list pgsql-hackers

From Haribabu kommi
Subject Re: insert throw error when year field len > 4 for timestamptz datatype
Date
Msg-id 8977CB36860C5843884E0A18D8747B0372BC6401@szxeml558-mbs.china.huawei.com
Whole thread Raw
In response to Re: insert throw error when year field len > 4 for timestamptz datatype  (Rushabh Lathia <rushabh.lathia@gmail.com>)
Responses Re: insert throw error when year field len > 4 for timestamptz datatype
List pgsql-hackers

On 27 September 2013 15:04 Rushabh Lathia wrote:

>>On Tue, Sep 17, 2013 at 6:23 PM, Haribabu kommi <haribabu.kommi@huawei.com> wrote:

>>I feel changing the year value to accept the length (>4) is not simple.

>>So many places the year length crossing more than length 4 is not considered.

>>Search in the code with “yyyy” and correct all related paths.

 

>Right, changing the year value to accept the length (>4) is not simple because so

>many places the year length crossing plus most of the please having assumption

>that it will be always <4.

 

>Tried to fix issue more couple of places but I don't feeling like its always going

>to be safe to assume that we covered all path.

 

>Still looking and wondering if we can do change in any simple place or whether

>we can find any other smarter way to fix the issue.

 

If the changes are very high to deal all scenarios,

I feel it is better do it only in scenarios where the use cases needs it, until it is not confusing users.

The rest can be documented.

Any other opinions/suggestions welcome.

 

Regards,

Hari babu.

pgsql-hackers by date:

Previous
From: Sawada Masahiko
Date:
Subject: Re: Patch for fail-back without fresh backup
Next
From: Robert Haas
Date:
Subject: Re: backup.sgml-cmd-v003.patch