*** rossand has quit IRC | 01:59 | |
*** rossand has joined #ingres | 02:34 | |
*** ChanServ sets mode: +o rossand | 02:34 | |
*** rossand has quit IRC | 03:22 | |
*** Alex|off is now known as Alex| | 06:09 | |
*** Alex| is now known as Alex|off | 06:31 | |
*** Alex|off is now known as Alex| | 06:43 | |
*** grantc_offline is now known as grantc | 07:36 | |
*** withdefault has joined #ingres | 08:35 | |
*** ChanServ sets mode: +o withdefault | 08:35 | |
Alex| | the training material tells me there is nobloblogging/journaling - anyone knows anything about it? | 09:22 |
---|---|---|
grantc | part of the create table statement | 09:23 |
grantc | ? | 09:23 |
Alex| | can't find it in the sql reference guide | 09:23 |
Alex| | google finds it only in the source code | 09:24 |
Alex| | 27-aug-2004 (stial01) | 09:24 |
Alex| | ** Removed SET NOBLOBLOGGING statement | 09:24 |
Alex| | hm... | 09:24 |
grantc | why does code have a cert for bugs .. :( | 09:25 |
grantc | I am shutting down apache on bugs/code/lxr.ingres.com for 5 mins | 09:29 |
grantc | apache is back and working now | 09:34 |
SlimeyPete | the copydb command uses "nojournaling" I think | 09:36 |
Alex| | "blob" - I read it in connection to blob performance enhancements | 09:36 |
Alex| | noblobjournaling | 09:36 |
SlimeyPete | oh right | 09:37 |
Alex| | but it seems this never really existed | 09:37 |
Alex| | and I don't know what exactly it was intended to do | 09:37 |
Alex| | I'll leave it out (preparing an upgrade presentation) | 09:38 |
withdefault | I think that it was created as you said for performance, nobloblogging is so that inserts and updates aren't written into the tx log so there is no recovery | 09:43 |
*** Tannah has joined #ingres | 09:53 | |
*** bonro011 has joined #ingres | 09:58 | |
*** bonro01 has quit IRC | 09:58 | |
*** Tannah has left #ingres | 10:01 | |
satanmalin | hi grant | 10:11 |
satanmalin | jhi evry one | 10:11 |
grantc | hi satanmalin | 10:11 |
satanmalin | everyone | 10:11 |
satanmalin | how r u grant / | 10:11 |
satanmalin | ? | 10:11 |
satanmalin | start my machine (***** Windows) ill be back asap | 10:13 |
*** satanmalin has quit IRC | 10:13 | |
Alex| | :) | 10:13 |
Alex| | heard his project is nearly done? ;) | 10:13 |
* grantc has ear plugs in | 10:14 | |
Alex| | hrhr | 10:14 |
grantc | someone recommended he use the 2.0 driver with the 1.4 demo app | 10:15 |
Alex| | wasn't me :) | 10:15 |
Alex| | but I'm sure this caused a lot of fun for you | 10:15 |
grantc | hmmm | 10:15 |
grantc | it's been very quiet until recently | 10:17 |
Alex| | seems it's no longer an Ingres USB stick? | 10:17 |
grantc | don't know about that | 10:18 |
SlimeyPete | hmmm... this is a little bit of a noob question, but I've not actually had to solve this problem before: | 10:18 |
SlimeyPete | I have two tables, linked by an integer key. I want to add a new row to table1, and then add a row with the same key to table2. | 10:19 |
SlimeyPete | But that means that, having done the insert into table1, I need to figure out what key was used. I can do it by generating an integer in 4GL code and storing it in a variable, but is there a cleaner way to do it (i.e. just using SQL/database structures) | 10:20 |
SlimeyPete | we've got a "seed" table which I could use, I guess... so long as I make sure to hold a lock on it until both inserts have been completed and the seed has been updated. | 10:22 |
*** satanmalin has joined #ingres | 10:22 | |
satanmalin | i'm back | 10:23 |
grantc | hi satanmalin | 10:23 |
satanmalin | sorry for disturbing you | 10:23 |
satanmalin | grant | 10:23 |
grantc | no problem | 10:24 |
satanmalin | i have good news | 10:24 |
grantc | cool | 10:24 |
satanmalin | Easy ingres is finnished on shitdows | 10:24 |
satanmalin | i only need your help for the demobase | 10:24 |
satanmalin | done by emma with the flight and the airport i dont know if you see what demo im talking about | 10:24 |
grantc | i know the application and the demodb | 10:25 |
grantc | i know of them would be a better way to put it | 10:25 |
grantc | SlimeyPete, perhaps you might be better off asking in the forums | 10:26 |
SlimeyPete | yeah, mebbe | 10:26 |
satanmalin | so what must I do to make it works ?? | 10:28 |
grantc | stéphane is looking at porting the code to use the new driver | 10:29 |
satanmalin | ok | 10:30 |
satanmalin | ill try to uppload Easy ingres | 10:30 |
satanmalin | so will be able to telleme if you like or if you hate ;-) | 10:30 |
grantc | where are you going to upload it to? | 10:31 |
satanmalin | i doint know on send it maybe | 10:39 |
grantc | how big is it? | 10:44 |
* SlimeyPete tries to figure out how one forces a transaction to use exclusive locks even for SELECT statements | 10:55 | |
grantc | set lockmode session where readlock = exclusive | 10:57 |
grantc | or something along those lines | 10:57 |
satanmalin | euh 94.2 Mb | 10:57 |
SlimeyPete | ah, lockmode | 10:57 |
SlimeyPete | thanks... I was looking at SET TRANSACTION | 10:57 |
grantc | perhaps that will do it too | 10:57 |
grantc | isolation level as well? | 10:57 |
satanmalin | sorry someone was talking to me | 10:58 |
satanmalin | LOL | 10:58 |
satanmalin | so grant to answer you 94.2 Mb | 10:58 |
grantc | not sure where you can stick that... | 10:58 |
satanmalin | wjy not on send it ? | 11:03 |
grantc | good luck | 11:04 |
grantc | not sure my email will accept a 100MB file | 11:04 |
grantc | one option is to upload to ftp.ingres.com but I don't know how that works. ask bruno/stéphane | 11:05 |
satanmalin | no | 11:05 |
satanmalin | on send it | 11:05 |
grantc | eh? | 11:06 |
satanmalin | its a site name where tyou can upload big files like rapidshare or megeupload | 11:06 |
grantc | ok | 11:06 |
satanmalin | sorry the site is yousendit | 11:06 |
satanmalin | ASAP i have the link ill give you | 11:14 |
grantc | ok | 11:15 |
* grantc wanders off to do some chores | 11:22 | |
*** rossand has joined #ingres | 12:19 | |
*** ChanServ sets mode: +o rossand | 12:19 | |
*** rossand has quit IRC | 13:05 | |
*** mull_ has joined #ingres | 14:03 | |
*** DarylM has joined #ingres | 14:13 | |
*** Alex| is now known as Alex|off | 14:49 | |
*** Alex|off is now known as Alex| | 15:00 | |
satanmalin | grant excuse me | 15:47 |
grantc | ? | 15:47 |
satanmalin | stephan told me that you have modiied | 15:47 |
satanmalin | something into the demo but i dont have the file modified | 15:48 |
satanmalin | (stef is away now) | 15:48 |
satanmalin | may I ask you to send me the new file please ? | 15:48 |
grantc | i sent stéf a basic port of the code, it does not work completely, in particular the profile page is not working | 15:48 |
grantc | i.e. you cannot load/modify existing profiles | 15:49 |
satanmalin | okio but i can see the base ? without modifying ? | 15:49 |
grantc | sure | 15:49 |
satanmalin | okoi may you send me the file please ? its better than have a 500 error LOL | 15:50 |
satanmalin | okoi = ok | 15:50 |
satanmalin | LOL | 15:50 |
satanmalin | sorry | 15:51 |
grantc | it's in the post | 15:51 |
satanmalin | ? | 15:51 |
grantc | 15:51 | |
grantc | 15:51 | |
satanmalin | satan etc .fr ? | 15:52 |
satanmalin | or another one ? | 15:52 |
grantc | orange.fr | 15:52 |
satanmalin | im checking | 15:53 |
satanmalin | damned pigeon He is too slow to give me the mail LOOOOOOOL | 15:53 |
satanmalin | nothing in my mail | 15:55 |
satanmalin | strange | 15:55 |
grantc | perhaps it went as spam? | 15:55 |
satanmalin | nop | 15:55 |
satanmalin | nope | 15:55 |
satanmalin | Nothing in my spam folder and nothing in my incoming mail | 15:55 |
grantc | perhaps a problem with ingres's mail server or orange.fr? | 15:56 |
satanmalin | maybe | 15:57 |
satanmalin | but its bizare i recieve other mail | 15:57 |
grantc | give it 30 minutes if it has not arrived i will try and sort another way | 15:57 |
satanmalin | oki grant | 15:59 |
satanmalin | really thank you | 15:59 |
satanmalin | and sorry for having distured you | 15:59 |
satanmalin | disturbed | 16:00 |
grantc | no problem | 16:01 |
grantc | i am surprise neither stef nor bruno have not sent it on | 16:01 |
satanmalin | bruno is not in the office today | 16:02 |
satanmalin | and stef thought that you have still sent me the file in FW | 16:02 |
grantc | perhaps | 16:03 |
satanmalin | did you manage to get married (problem of documents you said last time we met) | 16:04 |
grantc | yeah the documents were sorted in the end via something that i called enchufe in spanish or "knowing people" in english | 16:05 |
grantc | not i - we call... | 16:05 |
satanmalin | LOL | 16:07 |
satanmalin | oki | 16:07 |
grantc | we got married on halloween last year | 16:07 |
satanmalin | cooooool | 16:07 |
satanmalin | congratulations | 16:07 |
grantc | i thought you might like that :) | 16:07 |
satanmalin | why ?? because it was halloween ? | 16:08 |
satanmalin | LOL | 16:08 |
satanmalin | still have nothing in my mailbox | 16:09 |
*** AdrianH has joined #ingres | 16:10 | |
Alex| | rwc vpn still down? | 16:12 |
satanmalin | this is a test | 16:12 |
satanmalin | it's cool there's even machine translation, but is it good? | 16:12 |
satanmalin | is it worse than my english ? | 16:13 |
satanmalin | still nothing in my mail box I think the mail was lost en route | 16:15 |
grantc | Alex|, i can ping code which goes via rwc | 16:15 |
grantc | satanmalin, ok i will upload the two files | 16:15 |
satanmalin | terribly sorry | 16:16 |
grantc | Alex|, i cannot ping the box for ingres.com et. | 16:16 |
grantc | et. al. | 16:16 |
grantc | satanmalin, no problem | 16:16 |
Alex| | I mean the cisco vpn, vpnc tells me to check the group password | 16:16 |
Alex| | not the rackspace vpn | 16:16 |
grantc | ah | 16:16 |
Alex| | there was a firewall maintenance today but I thought it would be up again | 16:17 |
grantc | they swapped out the Pixies which would have affected the RWC<->RS coms | 16:17 |
Alex| | hash comparison failed: check group password! | 16:19 |
grantc | satanmalin, http://croker.net/~grant/files/DBConnection.php and http://croker.net/~grant/files/php_ingres.dll | 16:19 |
grantc | Alex|, are you using the vpnc client or the cisco one? | 16:20 |
Alex| | vpnc | 16:20 |
Alex| | slough is fine... | 16:20 |
grantc | let me check | 16:20 |
grantc | ditto | 16:22 |
grantc | try the cisco client | 16:23 |
satanmalin | euh supid question as always how can i get the file ?? | 16:23 |
grantc | ah sorry ... | 16:23 |
satanmalin | when i click on the link I have a white page | 16:24 |
grantc | http://croker.net/~grant/files/DBConnection.txt | 16:24 |
satanmalin | only for DBConnection | 16:24 |
grantc | that's my fault... | 16:24 |
grantc | rename the file to DBConnection.php | 16:25 |
satanmalin | you have modified the php_ingres.dll ? | 16:25 |
grantc | its there too | 16:25 |
satanmalin | no i only ask you | 16:25 |
grantc | yes | 16:25 |
satanmalin | you have modified it since the 2.1 ? | 16:25 |
satanmalin | oki | 16:25 |
grantc | the DBConnection.php code uses a function not in 2.1 | 16:26 |
grantc | it's only in the CVS server | 16:26 |
satanmalin | oki so i have to replace the dll too | 16:26 |
satanmalin | oki | 16:26 |
satanmalin | thanks grant il try it now | 16:26 |
grantc | ok | 16:26 |
satanmalin | the dll you send is for php 5.2.9 ? | 16:27 |
satanmalin | sent | 16:27 |
grantc | 5.2.8 but it should work | 16:28 |
satanmalin | and ingres 9.2 build 141 | 16:28 |
satanmalin | ? | 16:28 |
satanmalin | oki ill try it | 16:28 |
grantc | 9.2 build 143 | 16:28 |
satanmalin | perfect | 16:29 |
satanmalin | i compile easy ingres and ill test it now | 16:29 |
grantc | ok | 16:30 |
satanmalin | thank you | 16:30 |
satanmalin | its comp;ilng | 17:06 |
satanmalin | (it is long cause cause ive done a mistake) | 17:06 |
satanmalin | i have just recieved the mail | 17:33 |
grantc | :) | 17:33 |
satanmalin | quiet quick LOOOOOOOOOOL | 17:33 |
grantc | i guess it was being checked for viruses since it had the dll | 17:33 |
satanmalin | im installing | 17:34 |
satanmalin | creating ima db | 17:34 |
satanmalin | .... | 17:35 |
satanmalin | 1 hour to check for viruses quiet quick LOL | 17:35 |
satanmalin | im reboting | 17:37 |
satanmalin | I have recieved Staphane 's mail too so i think a probleme of ingres mail | 17:38 |
grantc | perhaps | 17:39 |
satanmalin | IT WORKS | 17:41 |
satanmalin | thanks grant | 17:41 |
grantc | apart from the profile page | 17:41 |
satanmalin | i have access to the profile page | 17:41 |
satanmalin | but i dont have tried to modify sth | 17:41 |
satanmalin | tooooooooooooooooo coooooooooooooooooooooooooooooooooooooooooool | 17:43 |
*** clach04 has joined #ingres | 17:45 | |
*** rossand has joined #ingres | 17:47 | |
*** ChanServ sets mode: +o rossand | 17:47 | |
satanmalin | i;m upping the file | 17:47 |
*** DerMeister has joined #ingres | 18:20 | |
*** troal01 has joined #ingres | 18:50 | |
troal01 | Where in the Ingres code would one look to investigate what happens when CREATE LOCATIOn is issued on a session? | 18:59 |
DarylM | back/dmf/dmm/*loc*.c | 19:04 |
troal01 | Thank you very much DarylM | 19:05 |
troal01 | What was that wiki document called something Ingres code walkthrough? | 19:05 |
DarylM | Darn, I thought I had that one bookmarked | 19:07 |
DarylM | Start here? http://community.ingres.com/wiki/Getting_Started | 19:09 |
troal01 | I think this is the one I was thinking of: http://community.ingres.com/wiki/A_Short_Excursion_Through_The_Ingres_Back-End | 19:09 |
DarylM | Yup, that is the one I was thinking of :) | 19:09 |
* DarylM thinks back to a time when he thought it would be so cool to get the Ingres source, and quickly learned the true meaning of "Be careful what you ask for, you might get it" | 19:10 | |
troal01 | LOL! | 19:11 |
DarylM | ;) | 19:11 |
DerMeister | I once tried to debug the ingres php driver - I'm not sure if I really would want to mess around with the whole ingres sourcecode ;) | 20:22 |
troal01 | Very much agreed DerMeister :) | 20:25 |
*** DerMeister has quit IRC | 21:57 | |
satanmalin | DarylM are you still there ? | 22:03 |
satanmalin | I have the new version of easy Ingres | 22:04 |
DarylM | I am here | 22:04 |
*** Alex| is now known as Alex|off | 22:05 | |
DarylM | I have the beginnings of the Mac OS/X type of Easy Ingres :) | 22:05 |
satanmalin | do you want the link ? | 22:06 |
satanmalin | for the windows version | 22:07 |
satanmalin | Coooool | 22:07 |
DarylM | It would be more useful to know what the construction techniques, tools, and procedures are | 22:08 |
satanmalin | i have to change two things | 22:08 |
DarylM | I suspect the Unix approach to such a package would be dramatically different from the Windows version. | 22:09 |
satanmalin | but i have th eversion 0.99 if you wanna test it | 22:09 |
satanmalin | i know it | 22:09 |
DarylM | Links are good :) | 22:10 |
satanmalin | https://download.yousendit.com/TTZrb253YTJ5UkZFQlE9PQ | 22:10 |
DarylM | Thanks. It will take a while to clone the template VM I use for experiments and run it all | 22:21 |
satanmalin | lol | 22:22 |
satanmalin | now ill go to bed | 22:23 |
satanmalin | LOL | 22:23 |
DarylM | I started using VirtualBox over VMware and Parallels. Free :) | 22:23 |
satanmalin | cool | 22:24 |
troal01 | Can only use one core in VB images where as VMWare images can use more than one | 22:24 |
troal01 | Otherwise I would've probably gone VB too | 22:24 |
DarylM | WIndows sucks down so much processor power anyway, I don't want it to have more than 1 core of load | 22:24 |
DarylM | I never test anything that multiple cores are an important factor on a virtual environment anyway. | 22:25 |
troal01 | I was compiling some stuff in an image which having two cores made a lot of difference | 22:26 |
DarylM | Ah. | 22:26 |
troal01 | make -j is my friend :) cuts compile almost in half | 22:27 |
DarylM | I love "-j" | 22:27 |
DarylM | sadly, Ingres itself doesn't always play nice (jam) with parallel compiles | 22:27 |
troal01 | I haven't dared try that yet | 22:28 |
DarylM | Don't | 22:28 |
*** DarylM has quit IRC | 22:37 | |
*** mull_ has quit IRC | 23:00 | |
*** grantc is now known as grantc_offline | 23:17 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!