Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 84CC1650070
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 11 Aug 2008 10:32:16 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 20475-08 for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 11 Aug 2008 10:32:02 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.153])
	by postgresql.org (Postfix) with ESMTP id 227B964FD3E
	for <pgsql-admin@postgresql.org>; Mon, 11 Aug 2008 10:32:06 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so1462267fgg.23
	for <pgsql-admin@postgresql.org>; Mon, 11 Aug 2008 06:32:04 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:in-reply-to:mime-version:content-type:references;
	bh=N7yLe+MjjwS3c5rgamqfjlJcxWkP9NC1nLDh3bP76zY=;
	b=P1sl6fuMO0hfYZyEmP+wQKzOeDrtauxkI1el6rXehkQNfpUwOMGSaZ8YdlhROFESLj
	B1kSlo3SBl6qqnramVBT0Mot6KjqBds19+Fxab6z2QiwbV75VsBui4bFvCAE3G13wWwZ
	vqNgeDPaDLGz9kG9XphCKxQIqOO6JlRHkopx0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version
	:content-type:references;
	b=n31Yo5EupCrwbohUkj/YT/nIBDGWRwJtnhe0sr+CK0sUiAhs1clPefH4O1zDlBQAWn
	GPDc+BfTQjZOWE5NL2DUdgxB8ydltr3C//GVLDZ5nX9lKSREvcKbnOQp5z/yBCN79Rvj
	aukaEZzS1x3paqGm3jsmHL/dabl0JQ0tG2rh8=
Received: by 10.86.1.11 with SMTP id 11mr8053020fga.27.1218461524480;
	Mon, 11 Aug 2008 06:32:04 -0700 (PDT)
Received: by 10.86.71.10 with HTTP; Mon, 11 Aug 2008 06:32:04 -0700 (PDT)
Message-ID: <d3561eb00808110632p20a42cc4x2f8b6d0829fefcca@mail.gmail.com>
Date: Mon, 11 Aug 2008 19:02:04 +0530
From: "C K" <shreeseva.it@gmail.com>
To: pgsql-general@postgresql.org,
	"pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Fwd: setting datestyle
In-Reply-To: <d3561eb00808090557u63e70b23q9d6a7ad2052dbc88@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_64443_25311940.1218461524478"
References: <d3561eb00808090557u63e70b23q9d6a7ad2052dbc88@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200808/41
X-Sequence-Number: 29886

------=_Part_64443_25311940.1218461524478
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Dear Friends,
I have tried to set datestyle to 'DMY'. As per manual and many other posts
related to this point, I have set datestyle to 'DMY' at database. but still
it is needed to execute each time *set datestyle to 'DMY' *before starting
any new connection. Once this is set, there is no problem for that
connection till it was live. Is there any solution to this problem? Why even
after setting database property datastyle to 'DMY' gives an error when *set
datestyle to 'DMY' *is not executed at starting connection?

Please help.

Thanks
CPK

-- 
Keep your Environment clean and green.



-- 
Keep your Environment clean and green.

------=_Part_64443_25311940.1218461524478
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div dir="ltr">Dear Friends,<br><div class="gmail_quote"><div dir="ltr">I have tried to set datestyle to &#39;DMY&#39;. As per manual and many other posts related to this point, I have set datestyle to &#39;DMY&#39; at database. but still it is needed to execute each time <b>set datestyle to &#39;DMY&#39; </b>before starting any new connection. Once this is set, there is no problem for that connection till it was live. Is there any solution to this problem? Why even after setting database property datastyle to &#39;DMY&#39; gives an error when <b>set datestyle to &#39;DMY&#39; </b>is not executed at starting connection?<br>

<br>Please help.<br><br>Thanks<br>CPK<br clear="all"><br>-- <br>Keep your Environment clean and green.<br>
</div>
</div><br><br clear="all"><br>-- <br>Keep your Environment clean and green.<br>
</div>

------=_Part_64443_25311940.1218461524478--