the last letter missing at some maintainers names

Boris Samorodov bsam at ipt.ru
Fri Mar 13 02:19:14 EDT 2009


On Thu, 12 Mar 2009 22:54:42 +0100 Beat Gätzi wrote:
> Beat Gätzi wrote:
> > Boris Samorodov wrote:
> >> On Thu, 12 Mar 2009 21:31:41 +0100 Beat Gätzi wrote:
> >>> Boris Samorodov wrote:
> >>>> On Thu, 12 Mar 2009 21:20:31 +0100 Beat Gätzi wrote:
> >>>>
> >>>>> What kind of database and which version do you use?
> >>>> -----
> >>>> % pkg_info -xI postgresql
> >>>> postgresql-client-8.3.6 PostgreSQL database (client)
> >>>> postgresql-server-8.3.6 The most advanced open-source database available anywhere
> >>>> -----
> >>> I tested this changes with an older version of PostgreSQL and it worked.
> >>> # pkg_info -xI postgresql
> >>> postgresql-client-8.2.9 PostgreSQL database (client)
> >>> postgresql-server-8.2.9 The most advanced open-source database available
> >>> anywhere
> >>> I will upgrade my database to 8.3 and check if I could reproduce the
> >>> problem.
> >> Well, it's a feature, from PostgreSQL docs:
> >> -----
> >> "Remove the longest string containing only the characters (a space by
> >> default) from the start/end/both ends of the string"
> >> -----
> >> I.e. '@FreeBSD.org' in reality is a list of characters to be removed.
> >> It's equal to '@FreeBSD.org', 'org at BSDFre.', etc. ;-)
> > 
> > Yes, I also recognized that I misused the trim function... :-(
> > 
> >> One can use regexp_replace instead:
> >> -----
> >> tinderbox=# select regexp_replace('bsam at FreeBSD.org', '@FreeBSD.org$', '', 'g');
> >>  regexp_replace 
> >> ----------------
> >>  bsam
> >> (1 row)
> >> -----
> > 
> > Unfortunately this does not work with mySQL. I will try to find a
> > solution which work on both databases.

> Could you please try this patch:
> http://tmp.chruetertee.ch/TinderboxDS_trim.patch

> This should work with PostgreSQL and mySQL.

This works like a charm, thanks!


WBR
-- 
Boris Samorodov (bsam)
Research Engineer, http://www.ipt.ru Telephone & Internet SP
FreeBSD Committer, http://www.FreeBSD.org The Power To Serve


More information about the tinderbox-list mailing list