Re: Problem Setting DateStyle

Поиск
Список
Период
Сортировка
От Andy
Тема Re: Problem Setting DateStyle
Дата
Msg-id 003801c69933$58bad960$0b00a8c0@mpsro.dom
обсуждение исходный текст
Ответ на Problem Setting DateStyle  ("Andy" <frum@ar-sd.net>)
Ответы Re: Problem Setting DateStyle  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Problem Setting DateStyle  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список 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@sss.pgh.pa.us>
To: "Andy" <frum@ar-sd.net>
Cc: <pgsql-admin@postgresql.org>
Sent: Monday, June 26, 2006 5:50 PM
Subject: Re: [ADMIN] Problem Setting DateStyle


> "Andy" <frum@ar-sd.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
>
>

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problem Setting DateStyle
Следующее
От: Thomas Mack
Дата:
Сообщение: Aborting transactions