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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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