On Tue, April 11, 2006 4:24, Alec Thomas said:
> James,
>
> Are you using Postgres?
>
Yes
I tried applying this patch:
$ cat ticketpy.diff
Index: tractags/ticket.py
==================================================================
--- tractags/ticket.py (revision 230)
+++ tractags/ticket.py (working copy)
@@ -29,7 +29,7 @@
tags = set(tags)
names = set(names)
args = []
- sql = "SELECT id, %s, %s AS allfields FROM ticket" %
(','.join(self.fields),
+ sql = "SELECT * FROM (SELECT id, %s, %s AS allfields FROM
ticket) s" % (','.join(self.fields), '||'.join(["COALESCE(%s, '')" % f
for f in self.fields])) constraints = []
if names:
to my TracTags trunk export
(svn export http://muness.textdriven.com/svn/edu/support/trac/tags-plugin
workdir)
but I get this error:
patch < ticketpy.diff
(Patch is indented 4 spaces.)
patching file ticket.py
Hunk #1 FAILED at 29.
1 out of 1 hunk FAILED -- saving rejects to file ticket.py.rej
$ cat ticket.py.rej
***************
*** 29,35 ****
tags = set(tags)
names = set(names)
args = []
- sql = "SELECT id, %s, %s AS allfields FROM ticket" %
(','.join(self.fields),
if names:
--- 29,35 ----
tags = set(tags)
names = set(names)
args = []
+ sql = "SELECT * FROM (SELECT id, %s, %s AS allfields FROM
ticket) s" % (','.join(self.fields), '||'.join(["COALESCE(%s, '')" % f for
f in self.fields])) constraints = []
if names:
Regards,
Jim
--
*** e-mail is NOT a secure channel ***
James B. Byrne mailto:ByrneJB.<token>@Harte-Lyne.ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3CE delivery <token> = hal
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
