From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on sa.int.altlinux.org X-Spam-Level: X-Spam-Status: No, score=-1.5 required=5.0 tests=BAYES_00, DNS_FROM_OPENWHOIS, SPF_PASS autolearn=no version=3.2.5 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:sender:date:from:to:subject :message-id:references:mime-version:content-type:content-disposition :in-reply-to; bh=C2sdezc71kuYq6YvDch8p/3dc6ndXgn1fJsdanQSOpU=; b=o8OyJLmy6BOPmjDTGGaNN+XGaxWnqG4vQ2Rgwpw1gb+y4QrjWGHeSZZ2h7U+jOcS94 siPBd+w8KVO7JW4KQ326u801t7Qtoku5dtqQNUQd6wdy2/fjUhy8dCQorPjpcU4Z4hnK R/VB/ZzE16p6x9w8+hQpzrJ/OBEC9QSRUYeQs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=sender:date:from:to:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to; b=GBRYg0TObhzBX/Vgy6dKkfHddeKhWvB4zddUrdHsdf1CGk0om6kzRWit5Gdf0+s+Ov 6loCWXQa/nw+tbiJqPq/No+GbqDOzYW0BE2ygC5mwK0Trl+hoJVyX8ayrPa9X2uasXo0 06Q80vUAvgcXgI71KV15MKkceyKdXzJOQs+Dk= Sender: Denis Smirnov Date: Fri, 12 Nov 2010 19:39:23 +0300 From: "=?koi8-r?B?5MXOydMg883J0s7P1w==?=" To: ALT Linux Sisyphus discussions Message-ID: <20101112163923.GA2748@mw.mithraen.ru> References: <20101112074704.GA16999@altlinux.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="AhhlLboLdkugWU4S" Content-Disposition: inline In-Reply-To: Subject: Re: [sisyphus] postgresql index row X-BeenThere: sisyphus@lists.altlinux.org X-Mailman-Version: 2.1.12 Precedence: list Reply-To: ALT Linux Sisyphus discussions List-Id: ALT Linux Sisyphus discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 12 Nov 2010 16:39:34 -0000 Archived-At: List-Archive: List-Post: --AhhlLboLdkugWU4S Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Nov 12, 2010 at 06:06:59PM +0200, Igor Zubkov wrote: IZ> =F7=CF=D4 =DE=D4=CF =C2=D9 =D4=C1=CB=CF=CA =DA=C1=D0=D2=CF=D3 =CB =E2= =E4 =D2=C1=C2=CF=D4=C1=CC =C2=D9=D3=D4=D2=CF, =C1 =CE=C5 =CB=C1=CB =D3=C5= =CA=DE=C1=D3... IZ> ree-1.8.7-2010.02 > Changelog.where('changelogtext LIKE \'%CVE%\'').cou= nt IZ> =3D> 4288 IZ> ree-1.8.7-2010.02 > =EF=CE =CE=C5 =C2=D5=C4=C5=D4 =D2=C1=C2=CF=D4=C1=D4=D8 =C2=D9=D3=D4=D2=C5= =C5. =E9=C2=CF =C9=CE=C4=C5=CB=D3=D9 =D0=CF=CD=CF=C7=C1=C0=D4 =D4=CF=CC=D8= =CB=CF =C4=CC=D1 =D0=CF=C9=D3=CB=C1 _=D0=D2=C5=C6=C9=CB=D3=C1_. LIKE 'ABC%' -- =C9=D3=D0=CF=CC=D8=DA=D5=C5=D4 = =C9=CE=C4=C5=CB=D3=D9, =C1 LIKE '%CVE%' -- =D5=D7=D9, =CE=C5 =C9=D3=D0=CF=D8=CC=DA=D5=C0=D4. IZ>>> =3D=3D =9AAddIndexOnChangelogtext: migrating =3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D IZ>>> -- add_index(:changelogs, :changelogtext) IZ>> =EE=D5 =D7=CF =D0=C5=D2=D7=D9=C8 =C9 =D7=D0=D2=D1=CD=D8, "=C1 =CE=C1= =C8=D2=C5=CE=C1?!". IZ> =E4=CC=D1 =C2=D9=D3=D4=D2=CF=C7=CF =D0=CF=C9=D3=CB=C1. =E9=CE=C4=C5=D3=D9 =DC=D4=CF =CE=C5 =D0=D2=CF=D3=D4=CF "=DB=D4=D5=CB=C1 =DE= =D4=CF=C2=D9 =C9=D3=CB=C1=D4=D8 =D7=D3=C5 =C2=D9=CC=CF =C2=D9=D3=D4=D2=C5= =C5". =E5=D3=CC=C9 =C2=D9 =C2=D9=CC=CF =D4=C1=CB -- =D0=D2=CF=D3=D4=CF =D3=CF=DA=C4=C1=D7=C1=CC=C9 =C2=D9 =C9=CE= =C4=C5=CB=D3=D9 =CE=C1 =D7=D3=C5 =CB=CF=CC=CF=CE=CB=C9 =C9 =D2=C1=C4=CF=D7= =C1=CC=C9=D3=D8 =C2=D9 =D6=C9=DA=CE=C9 :) =FC=D4=CF =DB=D4=D5=CB=C1, =CB=CF=D4=CF=D2=C1=D1 =D0=CF=CD=CF=D6=C5=D4 =C9= =D3=CB=C1=D4=D8 =C2=D9=D3=D4=D2=C5=C5, =C5=D3=CC=C9 =D0=D2=C9=CD=C5=CE=D1= =C5=D4=D3=D1 =D0=D2=C1=D7=C9=CC=D8=CE=CF. "=F0=D2=C1=D7=C9=CC=D8=CE=CF" =CF=DE=C5=CE=D8 =DE=C1=D3=D4=CF =DC=D4=CF =C9= =DA=CD=C5=CE=C5=CE=C9=C5 =D3=D4=D2=D5=CB=D4=D5=D2=D9 =C2=C1=DA=D9, =C1 =CE= =C5 =D0=D2=CF=D3=D4=CF =D3=CF=DA=C4=C1=CE=C9=C5 =CE=D5=D6=CE=D9=C8 =C9=CE=C4=C5=CB=D3=CF=D7. >> =E4=C1=D6=C5 =C5=D3=CC=C9 =C2=D9 =DC=D4=CF =D2=C1=C2=CF=D4=C1=CC=CF -- = =DC=D4=CF =C2=D9=CC=CF =C2=D9 =D7=D3=C5 =D2=C1=D7=CE=CF =D5=D6=C1=D3=CE=CF.= =EF=D0=C9=DB=C9 =CB=C1=CB=D5=C0 >> =DA=C1=C4=C1=DE=D5 =D4=D9 =C8=CF=DE=C5=DB=D8 =D2=C5=DB=C9=D4=D8 =DC=D4= =C9=CD =D3=D4=D2=C1=CE=CE=D9=CD =C4=C5=CA=D3=D4=D7=C9=C5=CD, =C9 =D4=CF=C7= =C4=C1 =D4=C5=C2=C5 =D0=CF=C4=D3=CB=C1=D6=D5=D4 >> =CB=C1=CB =C5=C5 =D2=C5=DB=C9=D4=D8 =CB=D2=C1=D3=C9=D7=CF. IZ> =E4=C1=CE=CF =CD=CE=CF=C7=CF-=D0=D2=C9=CD=CE=CF=C7=CF =DA=C1=D0=C9=D3= =C5=CA =C9=DA changelog'=CF=D7 =D0=C1=CB=C5=D4=CF=D7. =F0=D2=C9=CD=C5=D2=CE= =CF: IZ> ree-1.8.7-2010.02 > Changelog.count(:all) IZ> =3D> 690859 IZ> ree-1.8.7-2010.02 > IZ> =F3=D4=CF=CC=D8=CB=CF :) IZ> =EF=C8=CF=D4=C1 =D7=D9=D4=C1=D3=CB=C9=D7=C1=D4=D8 =C9=DA =DC=D4=CF=CA = =CB=D5=DE=C9 =D4=CF=CC=D8=CB=CF =D4=C5 =D7 =CB=CF=D4=CF=D2=D9=C8 =C5=D3=D4= =D8 =D5=D0=CF=CD=C9=CE=C1=CE=C9=C5 =CF IZ> CVE. =E2=C5=DA =C9=CE=C4=C5=CB=D3=C1 =DC=D4=CF =D0=D2=CF=D3=D4=CF =CD= =C5=C4=CC=C5=CE=CE=CF. =E9=CE=C4=C5=CB=D3 =CE=C5 =C4=C5=CC=C1=C5=D4=D3=D1. IZ> =F7=CF=D4 =C4=D5=CD=C1=C0, =C1 =CE=C5 =D7=CF=D4=CB=CE=D5=D4=D8 =CC=C9 = =D4=D5=C4=C1 sphinx? =E9=CC=C9 =CB=C1=CB =C2=D9 =C5=DD=A3 =D2=C5=DB=C9=D4= =D8 =D4=C1=CB=D5=C0 =DA=C1=C4=C1=DE=CB=D5. =EE=C1 =DC=D4=C1=D0=C5 =C9=CD=D0=CF=D2=D4=C9=D2=CF=D7=C1=CE=C9=D1 %chanelog= =D7 =C2=C1=DA=D5 =D7=D9=D4=C1=D3=CB=C9=D7=C1=D4=D8 =DC=D4=C9 =D3=C1=CD=D9= =C5 CVE. =E9 =CB=CC=C1=D3=D4=D8 =D7 =CF=D4=C4=C5=CC=D8=CE=D5=C0 =D4=C1=C2=CC=C9=DE=CB=D5= =D3 =D0=CF=CC=D1=CD=C9 -- CVE,package,version =CB =CE=C5=CA =C4=D7=C1 =C9=CE=C4=C5=CB=D3=C1 -- =CF=C4=C9=CE =D0=CF CVE, = =C4=D2=D5=C7=CF=CA =D0=CF =D0=C1=D2=C5 package,version. version, =D2=C1=DA=D5=CD=C5=C5=D4=D3=D1, =CE=C5 =D7 =D3=CD=D9=D3=CC=C5 %ver= sion, =C1 =D0=CF=CC=CE=CF=D3=D4=D8=C0 -- =D7=CB=CC=C0=DE=C1=D1 serial =C9 release. =E5=D3=CC=C9 =CE=C1=CD =D0=D2=C9=C8=CF=C4=C9=D4=D3=D1 =DE=C1=D3=D4=CF =D7= =D9=D0=CF=CC=CE=D1=D4=D8 =CB=C1=CB=CF=CA-=D4=CF =D3=CC=CF=D6=CE=D9=CA =DA= =C1=D0=D2=CF=D3 -- =C5=C7=CF =CE=C5 =CE=C1=C4=CF =CF=D0=D4=C9=CD=C9=DA=C9=D2=CF=D7=C1=D4=D8. =EE=C1=C4=CF =C5=C7=CF =CC=C9= =CB=D7=C9=C4=C9=D2=CF=D7=C1=D4=D8, =C1 =D0=D2=C5=C4=D7=C1=D2=C9=D4=C5=CC=D8= =CE=CF =DA=C1=C7=CF=D4=CF=D7=CC=C5=CE=CE=D9=CA =D2=C5=DA=D5=CC=D8=D4=C1=D4 =C4=C5=D2=D6=C1=D4=D8 =D7 =CF=D4=C4=C5=CC=D8=CE= =CF=CA =D4=C1=C2=CC=C9=DE=CB=C5. --=20 =F3 =D5=D7=C1=D6=C5=CE=C9=C5=CD, =E4=C5=CE=C9=D3 http://mithraen.ru/ ---------------------------------------------------------------------------- --AhhlLboLdkugWU4S Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAkzdbbkACgkQPuR8c4jhFKILBwCgvh4mKbiBhAFTiPH+JHJvKXFY TDgAn1GIyzIkkPG2V/h/o+UQPF5FgjSP =91FZ -----END PGP SIGNATURE----- --AhhlLboLdkugWU4S--