Monday, 2009-06-22

*** grantc_ is now known as grantc01:07
grantcHi SlimeyPete02:05
*** grantc changes topic to "Ingres Chat | Wiki - http://community.ingres.com/wiki | Forums http://community.ingres.com/forum | Channel Archives http://irc.planetingres.org | PHP Ingres 2.2.0 released - http://pecl.php.net/ingres"02:05
*** grantc changes topic to "Ingres Chat | Community - http://community.ingres.com | Channel Archives http://irc.planetingres.org | PHP Ingres 2.2.0 released - http://pecl.php.net/ingres"02:08
SlimeyPetehi02:11
pborohi ppl :) just returned from Ireland, damn I love the country02:12
grantci thought you might want to know that 2.2.0 of the PHP driver has just been released02:12
SlimeyPeteneat.02:13
SlimeyPeteis there a changelog?02:13
grantcI have started to send out an email, in addition to the other posts i do (forum/blog/cdi/wiki). If you want I can add you to the distribution list02:13
SlimeyPetewe're moving to a new host soon, so I could ask our admins to upgrade the driver when we do so02:13
grantchttp://pecl.php.net/package/ingres/2.2.002:13
SlimeyPeteokay, that'd be neat. I'll pm you my address.02:13
grantcsomeone already found a bug :( but it's been fixed...02:14
grantchttp://pecl.php.net/bugs/bug.php?id=1668802:14
grantcor will be when I submit the paperwork02:14
*** withdefault has joined #ingres02:51
*** ChanServ sets mode: +o withdefault02:51
*** Alex| has joined #ingres03:09
*** ChanServ sets mode: +o Alex|03:11
*** atrofast has joined #ingres04:11
atrofastDoes any one use yahoo messenger her?04:17
*** atrofast has quit IRC04:18
grantcnot in a long time, although i tried to connect the other day for some reason or other and it would not connect04:18
*** atrofast has joined #ingres04:47
*** Gerhard has joined #ingres04:51
atrofastWell if anyone does use Yahoo/Pidgin: http://www.celticwolf.com/useful-information/faqs/26-pidgin-yahoo05:05
*** rossand has joined #ingres05:49
*** ChanServ sets mode: +o rossand05:49
*** rossand has quit IRC05:50
*** rossand has joined #ingres05:54
*** ChanServ sets mode: +o rossand05:54
*** DarylM has joined #ingres06:14
*** rossand has quit IRC06:51
*** mull has joined #ingres07:22
*** Gerhard has quit IRC07:57
atrofastYou really should be able to order by/group by/restrict on long varchar columns08:02
atrofastIt's really crippling not being able to08:02
*** withdefault has quit IRC08:10
*** atrofast has quit IRC08:11
DarylMYou really want to sort on a column that could be many Gigabytes in size?08:18
DarylM(Not that I disagree....)08:18
grantcgive a man enough rope...08:20
DarylMand he will hand the support organization08:29
* DarylM chuckles08:30
DarylMhang*08:30
*** DerMeister has joined #ingres08:41
*** atrofast has joined #ingres08:54
atrofastNo I don't really want to sort on a column that IS several GBs, however in Postgres text is just unlimited text, could be 10 characters, could 100k... Regardless you can still perform basic operations on it such as order by/group by/restrictions. When porting apps to Ingres that assume such behaviour is available, it is really hard to work around it08:58
DarylMI had that problem porting Bugzilla to Ingres.08:59
atrofastHow bad?09:04
atrofastOne table/column or all across?09:04
*** Alex| has quit IRC09:50
*** rossand has joined #ingres09:51
*** ChanServ sets mode: +o rossand09:51
*** Alex| has joined #ingres09:51
*** ChanServ sets mode: +o Alex|09:51
*** Nornagest has joined #ingres09:52
*** grantc has quit IRC10:36
DarylMatrofast:  Well, there were only a few affected columns.  But as you have already observed, once you hit that situation, it is a real pain to deal with.10:43
DarylMFor the short term I ended up creating a 30,000 byte varchar column and enabled 64K pages.10:43
atrofastI get around it with a very nice hack (oxymoron?) that coerces the long varchars into varchar(32000) heh10:43
DarylMThat (sorta) works also, if you have a situation that lends itself well to it.10:44
atrofastIT works on a case by case basis, problem with Drupal is all the add on modules you can download10:45
atrofastI'd have to test all of them and create hacks for each of them that groups/sorts on long varchar10:45
atrofastNot pretty10:45
DarylMunderstatement10:47
*** thiagomz has joined #ingres10:47
atrofastOn another note, how do I apply an Ingres patch that I downloaded from esd?10:49
DarylMfollow the patch instructions? ...  ;)      unwrap the tar and execute utility/iiinstaller10:49
atrofastThe readme was an html file, boo :P10:51
DarylMI just type "open file.html"11:11
DarylMoh wait, I am on a Mac.11:11
DarylMLoL11:11
atrofastHeh11:13
atrofastThat wouldn't work on Fedora I'm afraid :P11:14
atrofast"firefox file.html" does however :D11:14
Alex|just do lynx instead of less :)11:14
atrofastOr that11:14
DarylMlynx for the win   he he11:30
*** Gerhard has joined #ingres13:11
*** Alex| has quit IRC13:16
*** Nornagest has quit IRC13:17
*** Gerhard has left #ingres13:40
*** DerMeister has quit IRC14:25
*** mull has quit IRC14:35
*** DarylM has quit IRC15:28
*** rossand has quit IRC16:49
*** zxiiro has quit IRC17:01
*** zxiiro has joined #ingres17:02
*** mull has joined #ingres17:05
*** atrofast has quit IRC17:33
*** atrofast has joined #ingres17:37
*** mull has quit IRC21:04
*** ChanServ sets mode: +v zxiiro22:18

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!