Re: Problem Setting DateStyle

From: "Andy" <frum(at)ar-sd(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problem Setting DateStyle
Date: 2006-06-26 15:15:20
Message-ID: 003801c69933$58bad960$0b00a8c0@mpsro.dom
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Steps:
1.
show datestyle
DateStyle
ISO, DMY

2.
set datestyle to 'SQL, DMY';
show datestyle;
DateStyle
SQL, DMY

>>>>>>>>>> this should be the good result.

Now the tries:
Edit the postgresql.conf. Set datestyle = 'SQL, DMY' parameter. Restart the
DB server.
show datestyle
DateStyle
ISO, DMY

... there is no change.

the other try:
alter database test2 set datestyle to 'SQL, DMY';
SQL executed.
show datestyle
DateStyle
ISO, DMY

the same...

Am I missing something??? If I set
set datestyle to 'SQL, DMY' in a connection session then it works well for
that session.

I need this type of format:
auftragsdatum
27/06/2005
27/06/2005
27/06/2005
27/06/2005
27/06/2005
27/06/2005
21/11/2005
09/12/2005
07/07/2005
29/06/2005

I don't know what am I missing in the configuration.
I attach the postgres.conf.

Best regards,
Andy.

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andy" <frum(at)ar-sd(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Monday, June 26, 2006 5:50 PM
Subject: Re: [ADMIN] Problem Setting DateStyle

> "Andy" <frum(at)ar-sd(dot)net> writes:
>> I tried to modify it in postgres.conf >>> datestyle = 'European' or
>> datestyle = 'SQL, DMY'
>> and I tried to make
>> alter database test5 SET DateStyle='SQL, DMY';
>
>> .... none of these worked.
>
> They work for me. Perhaps you should show us exactly what you did and
> what happened.
>
> regards, tom lane
>
>

Attachment Content-Type Size
postgresql.conf application/octet-stream 11.6 KB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2006-06-26 15:59:15 Re: Problem Setting DateStyle
Previous Message Thomas Mack 2006-06-26 15:09:11 Aborting transactions