pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSetting DateStyle
5+ messages / 4 participants
[nested] [flat]
* Setting DateStyle
@ 2002-10-22 17:44 Jeff Self <jself@nngov.com>
2002-10-22 20:11 ` Re: Setting DateStyle Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Jeff Self @ 2002-10-22 17:44 UTC (permalink / raw)
To: pgsql-admin
I'm trying to set my datestyle automatically in postgresql.conf this
way:
datestyle = 'iso, us'
But Postgresql won't start when I do this. I get the following message
in my logfile:
FATAL 1: 'datestyle' is not a valid option name
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Setting DateStyle
2002-10-22 17:44 Setting DateStyle Jeff Self <jself@nngov.com>
@ 2002-10-22 20:11 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2002-10-22 20:11 UTC (permalink / raw)
To: Jeff Self <jself@nngov.com>; +Cc: pgsql-admin
Jeff Self <jself@nngov.com> writes:
> I'm trying to set my datestyle automatically in postgresql.conf this
> way:
> datestyle = 'iso, us'
That will work as of PG 7.3, but not in prior releases. (Datestyle and
a couple of other slightly-weird SET variables didn't get folded into
GUC until 7.3.) The workaround in old releases is to set PGDATESTYLE in
the postmaster's environment, instead.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* setting datestyle
@ 2008-08-09 12:57 C K <shreeseva.it@gmail.com>
2008-08-11 13:32 ` Fwd: setting datestyle C K <shreeseva.it@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: C K @ 2008-08-09 12:57 UTC (permalink / raw)
To: pgsql-admin
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?
Please help.
Thanks
CPK
--
Keep your Environment clean and green.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Fwd: setting datestyle
2008-08-09 12:57 setting datestyle C K <shreeseva.it@gmail.com>
@ 2008-08-11 13:32 ` C K <shreeseva.it@gmail.com>
2008-08-11 13:49 ` Re: [GENERAL] Fwd: setting datestyle Tino Wildenhain <tino@wildenhain.de>
0 siblings, 1 reply; 5+ messages in thread
From: C K @ 2008-08-11 13:32 UTC (permalink / raw)
To: pgsql-admin
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?
Please help.
Thanks
CPK
--
Keep your Environment clean and green.
--
Keep your Environment clean and green.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [GENERAL] Fwd: setting datestyle
2008-08-09 12:57 setting datestyle C K <shreeseva.it@gmail.com>
2008-08-11 13:32 ` Fwd: setting datestyle C K <shreeseva.it@gmail.com>
@ 2008-08-11 13:49 ` Tino Wildenhain <tino@wildenhain.de>
0 siblings, 0 replies; 5+ messages in thread
From: Tino Wildenhain @ 2008-08-11 13:49 UTC (permalink / raw)
To: C K <shreeseva.it@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-08-11 13:49 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-10-22 17:44 Setting DateStyle Jeff Self <jself@nngov.com>
2002-10-22 20:11 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-08-09 12:57 setting datestyle C K <shreeseva.it@gmail.com>
2008-08-11 13:32 ` Fwd: setting datestyle C K <shreeseva.it@gmail.com>
2008-08-11 13:49 ` Re: [GENERAL] Fwd: setting datestyle Tino Wildenhain <tino@wildenhain.de>
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