SF.net SVN: ledger-smb:[5832] trunk

[..hidden..]

Revision: 5832
          http://sourceforge.net/p/ledger-smb/code/5832
Author:   einhverfr
Date:     2013-05-20 05:18:00 +0000 (Mon, 20 May 2013)
Log Message:
-----------
Fixing user creation failing with some datestyles and timezones, to be merged with 1.3

Modified Paths:
--------------
    trunk/Changelog
    trunk/sql/modules/admin.sql

Modified: trunk/Changelog
===================================================================
--- trunk/Changelog	2013-05-19 14:34:18 UTC (rev 5831)
+++ trunk/Changelog	2013-05-20 05:18:00 UTC (rev 5832)
@@ -94,6 +94,7 @@
 * Fixed tax boxes cannot be all unset (Chris T, 818)
 * Project, serial number, and notes now appear initially (Chris T, 824)
 * Fixed double-counting first date's balance on gl report (Chris T)
+* Fixed user creation failing on some timezones with some datestyles (Chris T)
 
 Changelog for 1.3.32
 * Fixed em-dash handling for pdfs (Chris T)

Modified: trunk/sql/modules/admin.sql
===================================================================
--- trunk/sql/modules/admin.sql	2013-05-19 14:34:18 UTC (rev 5831)
+++ trunk/sql/modules/admin.sql	2013-05-20 05:18:00 UTC (rev 5832)
@@ -339,7 +339,9 @@
     in_username text, 
     in_password TEXT,
     in_pls_import BOOL
-) returns int AS $$
+) returns int 
+SET datestyle = 'ISO, YMD'
+AS $$
     DECLARE
     
         a_user users;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.