Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5269764FD30 for ; Sat, 9 Aug 2008 09:57:45 -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 85390-07 for ; Sat, 9 Aug 2008 09:57:37 -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.156]) by postgresql.org (Postfix) with ESMTP id 81C5964FD2A for ; Sat, 9 Aug 2008 09:57:42 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so1051624fgg.23 for ; Sat, 09 Aug 2008 05:57:40 -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:mime-version:content-type; bh=ys8FNWyX9Scu2D2cmjhiuEMplZVJb1A4ZGRVWpwcG58=; b=iAnDFC5yD5TeYhfqkpQ2ELK+dVuaUsMLUplxv9eKVG653wfGZRdJ6Wvc9iXSof2a5B InMuac6f8Hio6eXPuWwu5dpbnLbz5khL6Zl7GxHKtMQCmblMyrRy1Nws3Tror1uqWrV4 sbyoA1mhHuJpsLNYCBgcVWvudfaFZFn48KS/I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=XvT9baYFIGn/OZoMIq4QRlXM0tw9m+BwvOzVN/ZSy93mdSKZrfStTzOENnQvZR7B11 YN5Qr3FwbjYtwnkaDq1Fb5e8JtcIxFLJd5vWtS9AekwMzYRYXiErhhCG9IkPYoYvNhkO mmJNgvaDaSvgu0wxp4mFZ/uM9KtbWwOHF+2wg= Received: by 10.86.92.7 with SMTP id p7mr4655355fgb.8.1218286660479; Sat, 09 Aug 2008 05:57:40 -0700 (PDT) Received: by 10.86.71.10 with HTTP; Sat, 9 Aug 2008 05:57:40 -0700 (PDT) Message-ID: Date: Sat, 9 Aug 2008 18:27:40 +0530 From: "C K" To: "pgsql-admin@postgresql.org" Subject: setting datestyle MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_45522_23919744.1218286660475" 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/37 X-Sequence-Number: 29882 ------=_Part_45522_23919744.1218286660475 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. ------=_Part_45522_23919744.1218286660475 Content-Type: text/html; 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.
------=_Part_45522_23919744.1218286660475--