Tuesday, 2009-06-09

grantc@config supybot.plugins.ChannelLogger.rotateLogs true05:59
ii_loggrantc: The operation succeeded.05:59
*** DarylM has joined #ingres05:59
*** grantc_ has joined #ingres06:00
*** ChanServ sets mode: +o grantc_06:00
grantc_og06:00
*** ii_log has joined #ingres06:04
grantcAlex|, i am looking at that NCLOB problem06:12
Alex|ok.. didn't hear anything from him yet06:12
grantcif you wish i can send a "patch" which contains a bunch of memory fixes06:13
Alex|sure...06:13
grantcthe NCLOB stuff is not working right now although i have an idea where the problem is06:13
*** ii_log is now known as ii_log206:16
*** ii_log2 is now known as ii_log06:17
grantci have a question regarding nclob data - how do you verify it's correct?06:20
Alex|shouldn't you know what you've put in? :)06:20
grantcif it does not come out ok, was it because of the insert or the select :)06:22
Alex|what a philisohical question :)06:22
Alex|did the tree make a sound when no one was there? ;p06:22
grantc:)06:23
grantcso now i am trying to find a tool to view the data that is not php...06:23
grantci wonder if python works06:24
Alex|vdba?....06:24
grantcon linux ?06:25
Alex|whatever... :)06:25
Alex|squirrel06:25
Alex|dtp, idw, ...06:25
grantcdtp is what i am looking at but I don't know where to get the DTP modules for ingres from for 3.206:27
Alex|eclipse 3.2?06:28
Alex|not sure there is one... there is an Ingres plugin for dtp 1.5 which was for Eclipse 3.3 (maybe also 3.2) but the newer Ingres plugin requires dtp 1.6 and that I think requires Eclipse 3.3 or even 3.406:29
grantci found rico's internal repo but saw it needed 3.3 like you mentioned06:30
Alex|idw is standalone and requires no installation... still you more or less get another eclipse with it...06:30
grantcperhaps i will give that a go06:31
Alex|still in heavy development but it's a start06:31
Alex|the new openroad based query tool!... also win only...06:31
grantcdoes the OR query tool do unicode?06:32
Alex|yes06:32
Alex|I didn't see it yet but I uploaded it with Chris on ESD and the text says it supports unicode06:32
grantc:)06:33
grantctime for lunch - i will take a look later one06:34
atrofastgrantc: testing your idea for libxerces on ubuntu 9.0407:19
atrofastAnd also using J's patch to fix mkdefault.sh07:19
*** rossand has quit IRC07:24
grantcAlex|, idw seems to have done the trick...07:36
grantcalthough selecting 2 nclobs is causing a problem07:36
grantcin idw that is07:36
grantcatrofast, what idea?07:37
atrofastusing ls, pipes and grep/sed to get the version of xerces07:38
grantcah - it should work since i use 9.0407:39
grantcit's based on what Alex|  does for gentoo07:39
atrofastIt should work on just about any Linux distro I think07:40
atrofastAs long as libs are stored in /usr/lib07:40
atrofastIt would break if someone compiled it themselves and put it in /usr/local/lib07:41
grantcfair enough, i guess we could parse ld.conf07:42
atrofastShouldn't be too hard :)07:44
Alex|does it handle xerces 3?07:47
Alex|because they changed the name pattern since 307:47
grantcdoes ingres support xerces3?07:48
Alex|libxerces-c.3.so or something instead of libxerces-c.so.2x07:48
Alex|do we support anything else than 2.5?... it compiles and runs with 3 if you mean that :)07:48
grantcfair enough07:49
Alex|I think my latest hack fpr that was to see where libxerses-c.so is symlinked to and have the actual lib name completly dynamical then... but that only works for systems where libxerces-c.so is a symlink to the real lib07:50
grantcwould the proper way be to write a C program to extract the version?07:52
Alex|from where would it get the version?07:52
grantci would imagine there is a version in the header files07:52
grantcthere is07:54
Alex|many hpp in /usr/include/xercesc07:54
grantcXERCES_VERSION_MAJOR and XERCES_VERSION_MINOR in util/XercesVersion.hpp07:54
Alex|ah right there07:54
atrofastDid xerces 3 change that directory structure any?07:56
Alex|whereas I still think that we simply should link against libxerces-c and not a hardcoded version....07:56
grantcyup...07:56
Alex|would avoid the whole problem07:56
grantcatrofast, are you going to flesh out that drupal page a bit more?07:57
grantci.e. document the issues you have?07:57
Alex|I think the argument was, there could be several xercesc versions on a system - in which case, dynamically finding the version wouldn't change anything07:57
atrofastSure, I can do that07:57
Alex|IT strategy meeting... I'm off...07:58
*** Alex| is now known as Alex|off07:58
atrofastgrantc: with your patch + CVS head on Ingres 9.2 I didn't really notice anything wrong. The only issue that remains for me was the LOB one and LONG VARCHARs08:05
grantccan you document those in the wiki08:06
atrofastYep08:07
grantcta08:07
atrofastIs it just me or is the graphics/wiki messed up?08:07
grantcwhich page?08:08
atrofastAll of it08:09
grantcit's ok for me - flush your caché08:11
* DarylM thinks that after an Apple World Wide Developer Conference, there are plenty of ways to flush my cash...... :)08:14
DarylMIt would be fascinating to see what the new OpenCL multi-threading environment means for databases.08:16
DarylMhttp://www.khronos.org/opencl/08:16
atrofastYeah damn Apple, I want to get the new iPhone :P08:17
*** withdefault has joined #ingres08:28
*** ChanServ sets mode: +o withdefault08:28
withdefaultHello all, In the IUA session for Ingres road map08:28
pboroahh, that's interesting part :)08:30
withdefaultGoing through the rationale of new features and road map08:32
withdefaultstrategy08:36
withdefault- smaller releases more often08:36
withdefault- Push the product08:36
withdefault- directed at new oppotunities08:36
withdefaultBe flexible and reliable08:36
withdefaulttable procedures - 9.3 in qa08:39
withdefaultIdentity columns - 9.3 in qa08:39
withdefaultsequence data type - 9.3 in qa08:39
withdefaultLike for LOBs - 9.3 in qa08:39
withdefaultRegex pattern matcing - 9.3 in qa08:39
withdefaultJDBC 4.0 - 9.4 in process08:39
withdefaultLong identifiers - 9..4 in process08:39
grantcooo regexp08:39
atrofastwithdefault: Like for LOBs as in where lob_col LIKE "something%something"?08:41
withdefaultIngres road map will look different to other vendors as the functionality will be released in smaller chunks.08:41
grantclob support for regex search?08:41
withdefaultatrofast, yes08:41
atrofastSweet :)08:41
withdefaultgrantc, don't know08:41
withdefaultLooking for suggestions in the 9.4 roadmap - take a look at the community wiki08:42
withdefaultsome discussion on Nulls in unique columns feature required for JBoss AS - as a configurable migration feature08:44
withdefaultI'm also trying to update http://community.ingres.com/wiki/UK_IUA_2009 too08:45
withdefaultquestion from the floor - migration from MySQL seems to be misplaced in prioities, wouldn't it be better to target Oracle PL/SQL08:47
withdefaultor enhance Ingres dbproc language to make it better08:48
withdefaultfor example arrays with db procs08:48
withdefaultallow ddl within db procs08:48
*** DerMeister has joined #ingres08:49
withdefaultBill - for dbprocs; try to improve and make it debuggable by reusing OR infrastructure08:50
withdefaultRoger - different way to address migrate PL/SQL applications by working with partners to replace PL/SQL in the application server and fits with the RedHat/JBoss/Ingres stack08:51
withdefaultRollfowarddb to a different name08:52
withdefaultAdd or drop partition scheme - convert a partition to table or vice versa08:53
withdefaultQBF column hiding - reply is to try the new gui query tool08:55
withdefaultor database workbench08:56
withdefaultMake statistics on tables an SQL command08:56
withdefaultAdd a column to a table make it positional - alter table display column order - for example in help table08:58
withdefaultOnline sysmod08:58
withdefault* Silent tm monitor output - data only09:01
withdefault* copydb - recreate dependencies09:01
withdefault* recognise synonyms in copydb09:01
withdefault* ability to see view table dependencies09:01
withdefault Parallel reload09:01
withdefaultmeeting is coming to a close09:01
withdefaultdone09:02
withdefaultThere will be a page that Christine will publish on the community wiki09:06
withdefaulttalk to you all later09:07
*** withdefault has left #ingres09:07
grantccya09:07
*** rossand has joined #ingres09:26
*** ChanServ sets mode: +o rossand09:26
*** rossand has quit IRC10:07
*** Alex|off is now known as Alex|11:09
*** rossand has joined #ingres11:25
*** ChanServ sets mode: +o rossand11:25
DarylMIngres creates an application calls "bitsin" during a build (svn source) but a "jam clean" at the top level does not seem to remove the built image.  Seems like a build script bug....12:39
*** rossand has quit IRC13:34
*** Alex| is now known as Alex|off13:39
*** rossand has joined #ingres14:13
*** ChanServ sets mode: +o rossand14:13
*** DerMeister has quit IRC14:19
*** rossand has quit IRC14:24
*** DarylM has quit IRC15:52
*** atrofast1 has joined #ingres16:05
*** mull has quit IRC16:14
*** zxiiro has quit IRC16:20
*** zxiiro has joined #ingres16:21
*** ChanServ sets mode: +v zxiiro16:21
*** atrofast1 has quit IRC16:46
*** atrofast1 has joined #ingres16:46
*** atrofast1 has quit IRC17:17
*** toumi01 has quit IRC18:51
*** zxiiro has quit IRC19:06
*** Alex|off is now known as Alex|22:10
*** Alex| is now known as Alex|off22:39
*** Alex|off is now known as Alex|22:54
*** withdefault has joined #ingres23:35
*** ChanServ sets mode: +o withdefault23:35

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