setting datestyle

From: "C K" <shreeseva(dot)it(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: setting datestyle
Date: 2008-08-09 12:57:40
Message-ID: d3561eb00808090557u63e70b23q9d6a7ad2052dbc88@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message H. Hall 2008-08-09 20:03:40 Re: Problems with connection
Previous Message Charles N. Charotti 2008-08-08 16:29:24 Best file system from PG on OpenBSD

Browse pgsql-general by date

  From Date Subject
Next Message Glyn Astill 2008-08-09 16:21:34 Re: Initdb problem on debian mips cobalt: Bus error
Previous Message hubert depesz lubaczewski 2008-08-09 09:19:27 Re: Disk space occupied by a table in postgresql