[Yaacs-svn] SF.net SVN: yaacs:[2181]

[<si...@us...>]

Revision: 2181
          http://yaacs.svn.sourceforge.net/yaacs/?rev=2181&view=rev
Author:   sickpig
Date:     2012-10-01 10:00:23 +0000 (Mon, 01 Oct 2012)
Log Message:
-----------
 * FIX: fix retrieving of bytea data from pg >= 9.0 server. 
   Defaulting bytea output from the backend to use hex mode 
   encoding, which is incompatible with pre-9.0 interfaces.
   see 9.0 release note: 
   http://www.postgresql.org/docs/9.0/static/release-9-0.html#AEN100465

   the possible solution are: 
   - ALTER DATABASE foo SET bytea_output='escape' ; 
   - change bytea_output to 'escape' in postgresql.conf
   - or just use encode(bytea,'escpape') to get the 
     same pre-9.0 output from your queries 
   
   we've chosen the third one cause it's less invasive
   and permit us to have different kind of clients at the
   same time. basically you can have a client linked to a 
   per-9.0 libpq and a newer one linked againt libpq >= 9.0 
   without tweaking server configuration. 

Modified Paths:
--------------
    branches/external-stable/yaacs/cati.tcl
    branches/external-trunk/yaacs/cati.tcl
    branches/internal-stable/yaacs/cati.tcl
    trunk/yaacs/cati.tcl

Modified: branches/external-stable/yaacs/cati.tcl
===================================================================
--- branches/external-stable/yaacs/cati.tcl	2012-09-25 07:52:12 UTC (rev 2180)
+++ branches/external-stable/yaacs/cati.tcl	2012-10-01 10:00:23 UTC (rev 2181)
@@ -1108,7 +1108,7 @@
 	if {$newLia == 0} {return 0}
 
 	set sql "select email_template as email, invite_template as invite, \
-		sms_text as sms, fax_template as fax, extract(epoch from mtime) as mtime \
+		sms_text as sms, encode(fax_template,'escape') as fax, extract(epoch from mtime) as mtime \
 		from projects.projects_lia where proj=$pj and extract (epoch from mtime) > $mtime"
 	array set result [::yadb::getTupleArray $db $sql]
 	if {[array size result] == 0} {return [list]}

Modified: branches/external-trunk/yaacs/cati.tcl
===================================================================
--- branches/external-trunk/yaacs/cati.tcl	2012-09-25 07:52:12 UTC (rev 2180)
+++ branches/external-trunk/yaacs/cati.tcl	2012-10-01 10:00:23 UTC (rev 2181)
@@ -1109,7 +1109,7 @@
 	if {$newLia == 0} {return 0}
 
 	set sql "select email_template as email, invite_template as invite, \
-		sms_text as sms, fax_template as fax, extract(epoch from mtime) as mtime \
+		sms_text as sms, encode(fax_template,'escape') as fax, extract(epoch from mtime) as mtime \
 		from projects.projects_lia where proj=$pj and extract (epoch from mtime) > $mtime"
 	array set result [::yadb::getTupleArray $db $sql]
 	if {[array size result] == 0} {return [list]}

Modified: branches/internal-stable/yaacs/cati.tcl
===================================================================
--- branches/internal-stable/yaacs/cati.tcl	2012-09-25 07:52:12 UTC (rev 2180)
+++ branches/internal-stable/yaacs/cati.tcl	2012-10-01 10:00:23 UTC (rev 2181)
@@ -1109,7 +1109,7 @@
 	if {$newLia == 0} {return 0}
 
 	set sql "select email_template as email, invite_template as invite, \
-		sms_text as sms, fax_template as fax, extract(epoch from mtime) as mtime \
+		sms_text as sms, encode(fax_template,'escape') as fax, extract(epoch from mtime) as mtime \
 		from projects.projects_lia where proj=$pj and extract (epoch from mtime) > $mtime"
 	array set result [::yadb::getTupleArray $db $sql]
 	if {[array size result] == 0} {return [list]}

Modified: trunk/yaacs/cati.tcl
===================================================================
--- trunk/yaacs/cati.tcl	2012-09-25 07:52:12 UTC (rev 2180)
+++ trunk/yaacs/cati.tcl	2012-10-01 10:00:23 UTC (rev 2181)
@@ -1109,7 +1109,7 @@
 	if {$newLia == 0} {return 0}
 
 	set sql "select email_template as email, invite_template as invite, \
-		sms_text as sms, fax_template as fax, extract(epoch from mtime) as mtime \
+		sms_text as sms, encode(fax_template,'escape') as fax, extract(epoch from mtime) as mtime \
 		from projects.projects_lia where proj=$pj and extract (epoch from mtime) > $mtime"
 	array set result [::yadb::getTupleArray $db $sql]
 	if {[array size result] == 0} {return [list]}

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