X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 46AFD9F9FE3 for ; Mon, 26 Jun 2006 11:19:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 74261-07 for ; Mon, 26 Jun 2006 11:19:21 -0300 (ADT) X-Greylist: delayed 00:23:34.455919 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 868D79FA226 for ; Mon, 26 Jun 2006 11:19:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from ar-sd.net (mail.ar-sd.net [81.196.35.136]) by svr4.postgresql.org (Postfix) with ESMTP id 55CE05AF04A for ; Mon, 26 Jun 2006 13:55:45 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id C3F872F5AC for ; Mon, 26 Jun 2006 16:50:55 +0300 (EEST) Received: from ar-sd.net ([127.0.0.1]) by localhost (ar-sd.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19782-03 for ; Mon, 26 Jun 2006 16:50:53 +0300 (EEST) Received: from forge (forge.mpsro.dom [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id 0BEDA2F502 for ; Mon, 26 Jun 2006 16:50:53 +0300 (EEST) Message-ID: <014601c69928$3dd35740$0b00a8c0@mpsro.dom> From: "Andy" To: Subject: Problem Setting DateStyle Date: Mon, 26 Jun 2006 16:55:51 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0143_01C69941.613F2510" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2869 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/226 X-Sequence-Number: 22188 This is a multi-part message in MIME format. ------=_NextPart_000_0143_01C69941.613F2510 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I want to have the DD/MM/YYYY date format in my database without to = specify it with: SET DateStyle=3D'SQL, DMY' at every query.=20 I tried to modify it in postgres.conf >>> datestyle =3D 'European' or = datestyle =3D 'SQL, DMY' and I tried to make=20 alter database test5 SET DateStyle=3D'SQL, DMY'; .... none of these worked.=20 If I run in a session=20 SET DateStyle=3D'SQL, DMY'=20 then it is ok for that session.=20 How can I make it default for the whole system or at least for some = databases? OS: Suse 10, pgsql 8.0.3. Regards, Andy. ------=_NextPart_000_0143_01C69941.613F2510 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I want to have the DD/MM/YYYY date = format in my=20 database without to specify it with:
SET DateStyle=3D'SQL, DMY' at every = query.=20
 
I tried to modify it in postgres.conf = >>>=20 datestyle =3D 'European' or datestyle =3D 'SQL, DMY'
and I tried to make
alter database test5 SET = DateStyle=3D'SQL,=20 DMY';
 
.... none of these worked. =
 
If I run in a session
SET DateStyle=3D'SQL, DMY' =
then it is ok for that session. =
 
How can I make it default for the whole = system or=20 at least for some databases?
 
OS: Suse 10, pgsql 8.0.3.
 
Regards,
 
Andy.
------=_NextPart_000_0143_01C69941.613F2510--