Manav Kumar <mkumar(at)yugabyte(dot)com> writes:
> I have a doubt in the expected output file:
> src/test/regress/expected/horology.out
> After doing the reset DateStyle.
> Why output is still in 'Postgres, MDY' form rather than 'ISO, MDY'.
Because pg_regress.c does this:
setenv("PGDATESTYLE", "Postgres, MDY", 1);
which determines the environment for all the psql runs it
launches.
regards, tom lane