Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle
Date
Msg-id 4914FFF0.8020102@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Responses Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Ron Mayer wrote:
> Tom Lane wrote:
>> *pg_dump had better force Postgres mode*.  We can certainly do that with
>> a couple more lines added to the patch, but it's a bit troublesome that
>> we are boxed into using a nonstandard dump-data format until forever.

Ok.  I see that is the concern..

Rather than forcing Postgres mode; couldn't it put a
"set intervalstyle = [whatever the current interval style is]"
in the dump file?

That doesn't force us to using a nonstandard dump-data format (except
for the nonstandard "set intervalstyle" line).



pgsql-hackers by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle
Next
From: Tom Lane
Date:
Subject: Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle