Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 569FB4763E5 for ; Tue, 22 Oct 2002 16:11:04 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 65151476385 for ; Tue, 22 Oct 2002 16:11:03 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g9MKB3hR024990; Tue, 22 Oct 2002 16:11:03 -0400 (EDT) To: Jeff Self Cc: pgsql-admin@postgresql.org Subject: Re: Setting DateStyle In-reply-to: <1035308693.5691.17.camel@jselfpc> References: <1035308693.5691.17.camel@jselfpc> Comments: In-reply-to Jeff Self message dated "22 Oct 2002 13:44:53 -0400" Date: Tue, 22 Oct 2002 16:11:03 -0400 Message-ID: <24989.1035317463@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/197 X-Sequence-Number: 6055 Jeff Self writes: > I'm trying to set my datestyle automatically in postgresql.conf this > way: > datestyle = 'iso, us' That will work as of PG 7.3, but not in prior releases. (Datestyle and a couple of other slightly-weird SET variables didn't get folded into GUC until 7.3.) The workaround in old releases is to set PGDATESTYLE in the postmaster's environment, instead. regards, tom lane