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

Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> Tom Lane wrote:
>> There isn't any way to do that, unless you have a time machine in
>> your hip pocket.  The trouble with putting
>> set intervalstyle = something;
>> into the dump script is that older servers will (by default) report
>> an error on that line and keep right on chugging.

> Not necessarily.  Couldn't we put

>   select * from (select substring(version() from '[0-9\.]+') as version) as a
>   join (select generate_series(0,100000000000)) as b on(version<'8.4');
>   set intervalstyle = something;

> Or something similar in the dump file.

[ shrug... ]  It's still just one easily missable bleat.
        regards, tom lane