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

Re: BUG #1671: Long interval string representation rejected

From: Neil Conway <neilc(at)samurai(dot)com>
To: Mark Dilger <markdilger(at)yahoo(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1671: Long interval string representation rejected
Date: 2005-05-18 05:43:53
Message-ID: 428AD619.2040508@samurai.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Mark Dilger wrote:
> It appears that any string representation of an interval of length greater
> than 76 is rejected.  (76 = 51 + 25 = MAXDATELEN + MAXDATEFIELDS).  This
> appears to be a limitation enforced within function interval_in() in the
> file src/backend/utils/adt/timestamp.c

Yeah, this seems bogus. It's not even clear to me why MAXDATELEN + 
MAXDATEFIELDS is used as the size of that buffer in the first place. I 
don't know the datetime code particularly well; perhaps someone who does 
can shed some light on this?

-Neil

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-05-18 06:04:06
Subject: Re: BUG #1671: Long interval string representation rejected
Previous:From: Alexander VolkDate: 2005-05-18 01:22:30
Subject: Fw: Error when install

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