European dates with Win32 version

[Raymond O'Donnell]

Hi all,

This is probably a silly question, but.......how do I get European-
style dates with 8.0 for Win32?

I'm running on XP Pro, and I've tried adding -o "-o -e" to the pg_ctl
command line (as one would on Linux) - I had to edit the registry to
insert it at the end of the command line. However, the service falls
over with the following in the event log:

pg_ctl.exe: invalid option (null)

I also tried putting the same options in the "start parameters" part
of the properties sheet for the PostgreSQL service, but while the
service started without problem it made no difference to the date
output.

Any help will be appreciated.

--Ray O'Donnell

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
ro*@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Daniel Schuchardt]

Raymond O'Donnell schrieb:

This is probably a silly question, but.......how do I get European-
style dates with 8.0 for Win32?

do you know
# - Locale and Formatting -

datestyle = 'iso, dmy'

in postgresql.conf ?

[Raymond O'Donnell]

On 30 Aug 2004 at 18:19, Daniel Schuchardt wrote:

do you know
# - Locale and Formatting -
datestyle = 'iso, dmy'
in postgresql.conf ?

Now I do!! - that's fixed it - thanks.

--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
ro*@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Bruce Momjian]

OK, we just tested this on Win32 and it now works fine. Seems we must
have fixed it somehow between your report and now.

---------------------------------------------------------------------------

Raymond O'Donnell wrote:

Hi all,

This is probably a silly question, but.......how do I get European-
style dates with 8.0 for Win32?

I'm running on XP Pro, and I've tried adding -o "-o -e" to the pg_ctl
command line (as one would on Linux) - I had to edit the registry to
insert it at the end of the command line. However, the service falls
over with the following in the event log:

pg_ctl.exe: invalid option (null)

I also tried putting the same options in the "start parameters" part
of the properties sheet for the PostgreSQL service, but while the
service started without problem it made no difference to the date
output.

Any help will be appreciated.

--Ray O'Donnell

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
ro*@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.ph a.pa.us | [phone]
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Raymond O'Donnell]

On 7 Oct 2004 at 14:48, Bruce Momjian wrote:

OK, we just tested this on Win32 and it now works fine. Seems we must
have fixed it somehow between your report and now.

Good on ye! Someone else also pointed out to me the following in
postgresql.conf -

datestyle = 'iso, dmy'

- which I hadn't been aware of, and which has fixed my problem.
Thanks for the reply!

--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
ro*@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)