From: Tino Wildenhain <tino@wildenhain.de>
To: C K <shreeseva.it@gmail.com>
Cc: pgsql-general@postgresql.org, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [GENERAL] Fwd: setting datestyle
Date: Mon, 11 Aug 2008 15:49:41 +0200
Message-ID: <48A04375.3070309@wildenhain.de> (raw)
In-Reply-To: <d3561eb00808110632p20a42cc4x2f8b6d0829fefcca@mail.gmail.com>
References: <d3561eb00808090557u63e70b23q9d6a7ad2052dbc88@mail.gmail.com>
<d3561eb00808110632p20a42cc4x2f8b6d0829fefcca@mail.gmail.com>
C K wrote:
> Dear Friends,
> I have tried to set datestyle to 'DMY'. As per manual and many other
> posts related to this point, I have set datestyle to 'DMY' at database.
> but still it is needed to execute each time *set datestyle to 'DMY'
> *before starting any new connection. Once this is set, there is no
> problem for that connection till it was live. Is there any solution to
> this problem? Why even after setting database property datastyle to
> 'DMY' gives an error when *set datestyle to 'DMY' *is not executed at
> starting connection?
Maybe you have a setting at database or login level?
ALTER ROLE ... SET ... can be effective
or
ALTER DATABASE ... SET
These would override whatever you set in the config file.
Also config file changes only take effect when you
restart the cluster in most cases.
Regards
Tino
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.2K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tino@wildenhain.de, shreeseva.it@gmail.com
Subject: Re: [GENERAL] Fwd: setting datestyle
In-Reply-To: <48A04375.3070309@wildenhain.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox