|
From: Joseph T. <dra...@gm...> - 2004-11-01 14:12:15
|
Reverted for mysql. Postgresql users should drop that index, and
recreate it using the sql statements in
db_update_0.6.9_0.7.0_postgresql.sql
On Mon, 1 Nov 2004 12:30:45 +0100 (CET), Garvin Hicking
<squ...@su...> wrote:
> Hi Joseph!
>
> > I think this introduces our very first irreparable shift. Unless we
> > can figure out a way to keep fulltext searching working on MySQL and to allow
> > more than 4000 characters in a blog entry on PostgreSQL we'll need to split the
> > SQL into two files, at least for the indices.
>
> Hm, if postgresql really sucks that much that it can't define indexes not
> affecting the size of the indexed columns, then that's true. But I somehow can't
> believe that there is no workaround? I'll try to look into finding a good way to
> make an optional SQLite/MySQL statement which does not affect postgresql.
> Something like
>
> /*[CONDITIONAL:MYSQL,MYSQLI,SQLITE] CREATE {FULLTEXT} INDEX on ...*/
>
> and then strip the comment characters if the conditionals are met. But it would
> really suck to need to insert that into 0.7 at this stage :(
>
> > BTW, in what way does this "break" full text searching. It *should*
> > only make them slower as there's no index to reference when searching. I guess I
> > haven't a clue about how that works.
>
> It breaks it fully, because without fulltext keys, the fulltext search of mysql
> does not work. Since I currently am busy, would someone please revert the
> change? If users are upgrading to CVS, they are screwed...
>
>
>
> Regards,
> Garvin.
>
> --
> Garvin Hicking | Web-Entwickler | Make me happy:
> www.supergarv.de | #ICQ 21392242 | http://wishes.garv.info/
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Sybase ASE Linux Express Edition - download now for FREE
> LinuxWorld Reader's Choice Award Winner for best database on Linux.
> http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
> _______________________________________________
> php-blog-cvs mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/php-blog-cvs
>
--
Joseph Tate
Personal e-mail: jtate AT dragonstrider DOT com
Web: http://www.dragonstrider.com
|
