*** grantc_ is now known as grantc | 01:07 | |
grantc | Hi SlimeyPete | 02: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 | |
SlimeyPete | hi | 02:11 |
pboro | hi ppl :) just returned from Ireland, damn I love the country | 02:12 |
grantc | i thought you might want to know that 2.2.0 of the PHP driver has just been released | 02:12 |
SlimeyPete | neat. | 02:13 |
SlimeyPete | is there a changelog? | 02:13 |
grantc | I 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 list | 02:13 |
SlimeyPete | we're moving to a new host soon, so I could ask our admins to upgrade the driver when we do so | 02:13 |
grantc | http://pecl.php.net/package/ingres/2.2.0 | 02:13 |
SlimeyPete | okay, that'd be neat. I'll pm you my address. | 02:13 |
grantc | someone already found a bug :( but it's been fixed... | 02:14 |
grantc | http://pecl.php.net/bugs/bug.php?id=16688 | 02:14 |
grantc | or will be when I submit the paperwork | 02:14 |
*** withdefault has joined #ingres | 02:51 | |
*** ChanServ sets mode: +o withdefault | 02:51 | |
*** Alex| has joined #ingres | 03:09 | |
*** ChanServ sets mode: +o Alex| | 03:11 | |
*** atrofast has joined #ingres | 04:11 | |
atrofast | Does any one use yahoo messenger her? | 04:17 |
*** atrofast has quit IRC | 04:18 | |
grantc | not in a long time, although i tried to connect the other day for some reason or other and it would not connect | 04:18 |
*** atrofast has joined #ingres | 04:47 | |
*** Gerhard has joined #ingres | 04:51 | |
atrofast | Well if anyone does use Yahoo/Pidgin: http://www.celticwolf.com/useful-information/faqs/26-pidgin-yahoo | 05:05 |
*** rossand has joined #ingres | 05:49 | |
*** ChanServ sets mode: +o rossand | 05:49 | |
*** rossand has quit IRC | 05:50 | |
*** rossand has joined #ingres | 05:54 | |
*** ChanServ sets mode: +o rossand | 05:54 | |
*** DarylM has joined #ingres | 06:14 | |
*** rossand has quit IRC | 06:51 | |
*** mull has joined #ingres | 07:22 | |
*** Gerhard has quit IRC | 07:57 | |
atrofast | You really should be able to order by/group by/restrict on long varchar columns | 08:02 |
atrofast | It's really crippling not being able to | 08:02 |
*** withdefault has quit IRC | 08:10 | |
*** atrofast has quit IRC | 08:11 | |
DarylM | You really want to sort on a column that could be many Gigabytes in size? | 08:18 |
DarylM | (Not that I disagree....) | 08:18 |
grantc | give a man enough rope... | 08:20 |
DarylM | and he will hand the support organization | 08:29 |
* DarylM chuckles | 08:30 | |
DarylM | hang* | 08:30 |
*** DerMeister has joined #ingres | 08:41 | |
*** atrofast has joined #ingres | 08:54 | |
atrofast | No 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 it | 08:58 |
DarylM | I had that problem porting Bugzilla to Ingres. | 08:59 |
atrofast | How bad? | 09:04 |
atrofast | One table/column or all across? | 09:04 |
*** Alex| has quit IRC | 09:50 | |
*** rossand has joined #ingres | 09:51 | |
*** ChanServ sets mode: +o rossand | 09:51 | |
*** Alex| has joined #ingres | 09:51 | |
*** ChanServ sets mode: +o Alex| | 09:51 | |
*** Nornagest has joined #ingres | 09:52 | |
*** grantc has quit IRC | 10:36 | |
DarylM | atrofast: 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 |
DarylM | For the short term I ended up creating a 30,000 byte varchar column and enabled 64K pages. | 10:43 |
atrofast | I get around it with a very nice hack (oxymoron?) that coerces the long varchars into varchar(32000) heh | 10:43 |
DarylM | That (sorta) works also, if you have a situation that lends itself well to it. | 10:44 |
atrofast | IT works on a case by case basis, problem with Drupal is all the add on modules you can download | 10:45 |
atrofast | I'd have to test all of them and create hacks for each of them that groups/sorts on long varchar | 10:45 |
atrofast | Not pretty | 10:45 |
DarylM | understatement | 10:47 |
*** thiagomz has joined #ingres | 10:47 | |
atrofast | On another note, how do I apply an Ingres patch that I downloaded from esd? | 10:49 |
DarylM | follow the patch instructions? ... ;) unwrap the tar and execute utility/iiinstaller | 10:49 |
atrofast | The readme was an html file, boo :P | 10:51 |
DarylM | I just type "open file.html" | 11:11 |
DarylM | oh wait, I am on a Mac. | 11:11 |
DarylM | LoL | 11:11 |
atrofast | Heh | 11:13 |
atrofast | That wouldn't work on Fedora I'm afraid :P | 11:14 |
atrofast | "firefox file.html" does however :D | 11:14 |
Alex| | just do lynx instead of less :) | 11:14 |
atrofast | Or that | 11:14 |
DarylM | lynx for the win he he | 11:30 |
*** Gerhard has joined #ingres | 13:11 | |
*** Alex| has quit IRC | 13:16 | |
*** Nornagest has quit IRC | 13:17 | |
*** Gerhard has left #ingres | 13:40 | |
*** DerMeister has quit IRC | 14:25 | |
*** mull has quit IRC | 14:35 | |
*** DarylM has quit IRC | 15:28 | |
*** rossand has quit IRC | 16:49 | |
*** zxiiro has quit IRC | 17:01 | |
*** zxiiro has joined #ingres | 17:02 | |
*** mull has joined #ingres | 17:05 | |
*** atrofast has quit IRC | 17:33 | |
*** atrofast has joined #ingres | 17:37 | |
*** mull has quit IRC | 21:04 | |
*** ChanServ sets mode: +v zxiiro | 22:18 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!