Re: Doubt in reset date style - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Doubt in reset date style
Date
Msg-id CAKFQuwaUgM4Wjk6=-0-rEXHwctZD4nJrmfJwpzbbLC7oVidwPg@mail.gmail.com
Whole thread Raw
In response to Doubt in reset date style  (Manav Kumar <mkumar@yugabyte.com>)
List pgsql-bugs
On Wed, Apr 30, 2025 at 2:17 PM Manav Kumar <mkumar@yugabyte.com> wrote:
 
I don't see any Alter cmd which changes the default value of DateStyle as well.

There are many ways to change GUCs (I'm unsure where exactly this one comes into play, feel free to look or wait for others to comment).  Assume that the script, when the first thing it does is 'SHOW DateStyle;' when issuing "reset datestyle", will have its value reset to the shown value.  The calling environment has made it so that is the session default.

The session default is:

SHOW DateStyle;
   DateStyle  
---------------
 Postgres, MDY
(1 row)

David J.

pgsql-bugs by date:

Previous
From: Manav Kumar
Date:
Subject: Doubt in reset date style
Next
From: marcos sicat
Date:
Subject: Re: Postgres 17.4 is much slower than Postgres 15.12 using RECURSIVE