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 781B89FA6B2 for ; Mon, 26 Jun 2006 13:11:15 -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 50671-08 for ; Mon, 26 Jun 2006 13:11:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id E93CE9F9AD3 for ; Mon, 26 Jun 2006 13:11:04 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 26 Jun 2006 16:11:02 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 26 Jun 2006 11:11:02 -0500 Subject: Re: Problem Setting DateStyle From: Scott Marlowe To: Andy Cc: Tom Lane , pgsql-admin@postgresql.org In-Reply-To: <003801c69933$58bad960$0b00a8c0@mpsro.dom> References: <014601c69928$3dd35740$0b00a8c0@mpsro.dom> <29135.1151333441@sss.pgh.pa.us> <003801c69933$58bad960$0b00a8c0@mpsro.dom> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1151338262.4215.51.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 26 Jun 2006 11:11:02 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/233 X-Sequence-Number: 22195 On Mon, 2006-06-26 at 10:15, Andy wrote: > 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... Have you set a date style for this particular database (not the cluster) with an alter database statement before? I'd try to alter the database to have a certain datestyle and see if that helps.