*** rossand has quit IRC | 00:05 | |
*** rossand has joined #ingres | 02:06 | |
*** ChanServ sets mode: +o rossand | 02:06 | |
*** rossand has quit IRC | 03:40 | |
*** Alex|off is now known as Alex| | 06:09 | |
*** Alex| is now known as Alex|off | 06:43 | |
*** Gerhard has joined #ingres | 06:53 | |
*** Alex|off is now known as Alex| | 06:59 | |
*** grantc_offline is now known as grantc | 07:15 | |
pboro | http://pauli.borodulin.fi/blog/?p=38 | 07:16 |
---|---|---|
satanmalin | hi gerhard | 08:25 |
Gerhard | hi satanmalin | 09:28 |
Gerhard | I've received your installer file, will test it in the next days | 09:28 |
satanmalin | oki danke schon gerhard | 09:34 |
satanmalin | just one question are you a painter ? | 09:34 |
Gerhard | a painter? what do you mean? | 09:55 |
satanmalin | i saw on google a painter with the same name as you | 10:20 |
satanmalin | and thought irt was you | 10:21 |
satanmalin | a painter like ingres | 10:21 |
satanmalin | dali | 10:21 |
satanmalin | etc. | 10:21 |
Gerhard | no, I'm not a painter (-: | 10:26 |
satanmalin | oki LOL | 10:27 |
satanmalin | sorry | 10:27 |
satanmalin | i hope i hqve not ofeended you ? | 10:28 |
Gerhard | no problem | 10:47 |
pboro | :D | 11:06 |
*** rossand has joined #ingres | 11:22 | |
*** ChanServ sets mode: +o rossand | 11:22 | |
troal01 | When you run verifydb in report mode, where does the report get saved? | 11:31 |
pboro | errlog.log? | 11:31 |
troal01 | Well it only says a report is being run, nothing else | 11:32 |
pboro | hmh :/ | 11:32 |
grantc | troal01, i think it goes to the screen | 11:33 |
troal01 | Ah | 11:33 |
troal01 | But if it doesn't output anything | 11:33 |
troal01 | And I know there's something fishy | 11:33 |
troal01 | should I use xtable instead of table? | 11:33 |
grantc | dunno | 11:33 |
grantc | pboro, re your perl script - nice work | 12:34 |
grantc | any chance of a write up in the community wiki? | 12:34 |
pboro | I wish I had time :) So not right now, sorry :( I'm currently also writing a blog post about using VARCHARs versus LONG VARCHARs with some considerations | 12:35 |
grantc | ah ha - in that case you want to be added to planetingres.org? | 12:35 |
grantc | :D | 12:36 |
pboro | ahaha :) I do still have your proposion about that in my blog... maybe after the next writing | 12:36 |
grantc | oh go-on | 12:36 |
grantc | i can restrict it to your ingres only posts | 12:37 |
pboro | proposion? is that even a word... | 12:37 |
pboro | that would be nice :) | 12:37 |
grantc | http://pauli.borodulin.fi/blog/?tag=ingres&feed=atom | 12:37 |
grantc | proposition | 12:37 |
pboro | yeah :D | 12:37 |
pboro | I havent slept well after my trip to london | 12:38 |
grantc | too much rain= | 12:38 |
grantc | ? | 12:38 |
pboro | not because of the trip but because of hurry after the trip... | 12:38 |
grantc | ah | 12:38 |
pboro | it was sunny and approx 15 degrees of celsius, so verry nice weather :) | 12:38 |
pboro | best I could hope for | 12:38 |
pboro | now back to finland and it's minus eight and over minus fifteen during nights :S | 12:39 |
pboro | back in finland | 12:39 |
grantc | a bit of a shock | 12:39 |
pboro | I wonder if the spring ever going to arrive at all this year... | 12:39 |
grantc | it has been 20ºC+ here | 12:40 |
pboro | "whether the spring is ever going" | 12:40 |
Alex| | here it is just snowing a little bit at a few degrees plus | 12:40 |
pboro | at least London made my English worse | 12:40 |
grantc | pboro, you are on/in the planet.. http://planetingres.org/ - all your posts will get sent out on twitter too... | 12:40 |
grantc | http://twitter.com/planetingres | 12:41 |
pboro | ok, thanks | 12:41 |
grantc | you're welcome :) | 12:42 |
pboro | I'm trying to try write something useful every month | 12:42 |
pboro | trying to try :D | 12:42 |
pboro | I really need some sleep | 12:42 |
pboro | bye guys :) | 12:43 |
grantc | hot chocolate and whisky... | 12:43 |
*** thiagomz has joined #ingres | 13:14 | |
*** DarylM has joined #ingres | 13:30 | |
*** mull_ has joined #ingres | 13:32 | |
thiagomz | guys... | 13:36 |
thiagomz | ./reload.ing |& tee reload.log | 13:36 |
thiagomz | -bash: syntax error near unexpected token `&' | 13:36 |
thiagomz | what is the similar on bash or sh ? | 13:36 |
thiagomz | [ingres@sel-dit-02 dbsv]$ ./reload.ing | tee reload.log => worked ;-) | 13:37 |
*** DarylM has quit IRC | 13:54 | |
*** thiagomz_ has joined #ingres | 14:04 | |
*** troal01 has quit IRC | 14:13 | |
*** troal01 has joined #ingres | 14:16 | |
*** Alex| is now known as Alex|off | 14:17 | |
*** Gerhard has quit IRC | 14:18 | |
*** thiagomz has quit IRC | 14:21 | |
*** IngBot has quit IRC | 14:45 | |
thiagomz_ | guys... | 14:55 |
thiagomz_ | how do i unload that => │iicese │dba │Star-CDB │ | 14:56 |
thiagomz_ | │cese │dba │distributed │ | 14:56 |
*** IngBot has joined #ingres | 15:13 | |
*** toumi01 has joined #ingres | 15:27 | |
*** Alex|off is now known as Alex| | 15:30 | |
*** clach04 has quit IRC | 16:05 | |
*** mull_ has quit IRC | 16:27 | |
*** DarylM has joined #ingres | 17:57 | |
*** troal01 has quit IRC | 18:21 | |
*** DarylM has quit IRC | 18:24 | |
*** troal01 has joined #ingres | 18:48 | |
*** mull has joined #ingres | 19:06 | |
troal01 | What do these functions do in Ingres: LOtos, STcopy, STlength | 20:15 |
troal01 | I can guess STcopy and STlength (strcpy and strlen?) but waht about LOtos | 20:15 |
pboro | STcopy and STlength sound like string stuff... lemme check LOtos | 20:16 |
troal01 | Thanks a bunch pboro | 20:16 |
Alex| | http://lxr.ingres.com/lxr/source/src/cl/clf/lo_win/lotos.c#023 | 20:17 |
pboro | damn, Alex was faster :) | 20:18 |
troal01 | Thanks Alex|! and pboro for trying :) | 20:18 |
pboro | nicely aged code btw | 20:18 |
pboro | all the one row of it... | 20:19 |
troal01 | register? | 20:21 |
troal01 | What's that supposed to do? | 20:22 |
pboro | its an old hint for the compiler that it should keep the parameters in cpu's argument registers | 20:22 |
pboro | and not put them into stack etc. | 20:22 |
troal01 | Does it actually do anything on modern machines? | 20:23 |
pboro | depends on the compiler... as far as I know, GCC completely ignores it, maybe others too | 20:23 |
pboro | "The best reason not to bother with register is that modern compilers are far better at deciding what to put into registers than the vast majority of programmers." | 20:24 |
Alex| | gcc probably ignores just about everything that's from 1983 :) | 20:24 |
pboro | optimization hints in general are not nearly so important as they were 20 years ago | 20:25 |
troal01 | Yeah it ignores me too... never does what I want, and I'm from 1983! | 20:26 |
Alex| | see :) | 20:26 |
pboro | :D | 20:27 |
pboro | since there is only a limited amount of registers, using "register" may even be bad for performance in situations where the registers could have been used for something more useful... it's a bit of voodoo, different cpus have different amount of registers etc. | 20:29 |
pboro | I feel dirty. I just wrote 200 lines of MIPS assembler... | 20:31 |
*** grantc is now known as grantc_offline | 20:32 | |
troal01 | That's so cool pboro | 20:33 |
pboro | it's a stupid program for a mips programming course :D solves simple equations... | 20:34 |
troal01 | Still cool, It would be useful for hacking my PSP :D | 20:36 |
pboro | haha | 20:36 |
*** Alex| is now known as Alex|off | 21:14 | |
*** macyaway has joined #ingres | 23:10 | |
macyaway | ojj | 23:10 |
macyaway | Is there anybody still alive? | 23:10 |
macyaway | And maybe swedish? | 23:10 |
troal01 | I speak Swedish but I don't live there anymore macyaway :) | 23:15 |
macyaway | aww it doesnt matter really i am not planing to ravish you.... i just bumped in to this minor problem that i dunno where to put really | 23:16 |
macyaway | Maybe if you could assist me, i would like to do something with it, i would believe it is an integrity i should create ... but it looks odd | 23:17 |
macyaway | You see it sais like this: | 23:17 |
macyaway | Flera biograf kan ha samma namn men inte inom samma ort. | 23:17 |
macyaway | What do you say? | 23:17 |
troal01 | Is this a database design question? | 23:18 |
macyaway | It obviousely sais that i cant have redundancy on ort | 23:18 |
macyaway | yes =) | 23:18 |
macyaway | It is! | 23:18 |
troal01 | Okay so biograf_namn is not unique globally, however you need to check to see if when two biografs have the same namn, that their orts are different | 23:19 |
macyaway | But they are not | 23:20 |
macyaway | I got redundancy going on | 23:21 |
macyaway | It's like i got studio in luleå with 3 salar 2 times | 23:21 |
troal01 | You could always create a rule on insert | 23:21 |
macyaway | That is why i recon i should write an integrity | 23:21 |
macyaway | hum ... i never created a rule on insert | 23:22 |
macyaway | I only did create integrity on biograf where how do i make biograf studio to exist in only one city ? :( | 23:23 |
macyaway | Very depressing | 23:23 |
macyaway | I made that bloody ER diagram and the tables respecting the normal forms and since half an hour im stuck on this | 23:23 |
troal01 | Well your problem seems a little unusual to me, you might either a) want to check on the application side before inserting to make sure the constraint is satisfied or create a procedure and rule on teh DB side | 23:24 |
troal01 | Does it have to be done in a certain DBMS? Like Ingres? | 23:24 |
macyaway | Aye, we work in ingres | 23:24 |
troal01 | Oh duh | 23:25 |
troal01 | Do a unique on namn and ort | 23:25 |
macyaway | So i am not creating integrities? | 23:25 |
troal01 | create unique index on biograf (namn, ort); | 23:25 |
macyaway | Cuz you see .... I got these other things going on as well ...where i am to do | 23:26 |
macyaway | Varje aktör kan spela solika roller men inte inom samma film | 23:26 |
macyaway | Varje film visas på flera biografer samtidigt | 23:26 |
troal01 | Okay so unique the combination of aktor and film | 23:26 |
macyaway | aha ... so if i do a create index on biograf meaning that i make it into an isam it will solve it? | 23:27 |
macyaway | Just slap me if im off singing to bird ... but dont slap too hard | 23:28 |
macyaway | birds even | 23:28 |
troal01 | Hehe, you can also use it in a create table statement | 23:28 |
troal01 | create table biograf ( namn varchar(255), ort varchar(255), unique(namn, org)); | 23:28 |
troal01 | You might have to add with structure = btree ( or hash or isam) to the unique I didn't try it myself | 23:29 |
macyaway | Eventho if i do an isam on the column it will still show the ort ... cuz that just does indexing and sorting .... so it was a stupid idea :/ | 23:30 |
troal01 | Yes, you need to use the unique keyword | 23:30 |
macyaway | You are sure that it works with create table biograf ( namn varchar(255), ort varchar(255), unique(namn, ort)); | 23:31 |
troal01 | Hehe not 100% but it's my best guess, try to run it :) | 23:31 |
macyaway | And that means that on biograf every each biograf can exist in only one city? | 23:31 |
macyaway | I cant run it, im not at uni .. am on a vista and i work against a phpmy admin :D | 23:32 |
macyaway | I'm a luxury child you see huhuhu, rather dull but heh :/ | 23:32 |
troal01 | Yeah the combination of namn and ort has to be unique which means studio lule can only occur once | 23:32 |
troal01 | You can run Ingres on Vista :) | 23:32 |
macyaway | Got to get down this bloody vista it's killing me at every each reboot! | 23:32 |
troal01 | Linux FTW! | 23:33 |
macyaway | wtf? | 23:33 |
macyaway | ftw | 23:33 |
troal01 | For the win | 23:33 |
macyaway | hum o.O` | 23:33 |
troal01 | Kinda like saying something is the best | 23:33 |
macyaway | aha | 23:33 |
macyaway | cuz you see wtf is not the best | 23:34 |
troal01 | I know haha | 23:34 |
macyaway | Got a ubuntu kd on me mums | 23:34 |
macyaway | it's cool, friendly... she likes me... we like each other | 23:34 |
macyaway | I didnt figgure how to start it up tho ... she got to push the button so i can manoover it | 23:35 |
troal01 | Hehehe, I used to use Ubuntu | 23:35 |
macyaway | but this is ubuntu kd :P | 23:35 |
macyaway | Really odd tho, had to install kopete and the old bird pidgeon | 23:35 |
macyaway | Dunno why the kopete died on yahoo msg .. so mum got a hard time starting up both of them and got to bugger arround in the sys quite often ... she lives like 3 days and nights away from sweden so i cant just run over and fix it :/ | 23:36 |
troal01 | Ah so you're not from Sweden originally? | 23:38 |
macyaway | Noooo | 23:38 |
troal01 | Just going to school there? :) | 23:38 |
macyaway | I'm a transylvanian little devil .. men behärskar Svenska språket rejält bra säger dem, i alla fall det blev att jag tar fristående kurser här i ume | 23:38 |
macyaway | Aye :) | 23:39 |
troal01 | I've not been to Sweden in like six years, your Swedish is probably better than mine! :) | 23:40 |
* macyaway smirk | 23:40 | |
macyaway | 's | 23:41 |
macyaway | I got to remember a lot of skills to check up where ya are ... lets see :D | 23:41 |
macyaway | got yer dns :P | 23:42 |
macyaway | Now i just got to remember where is it that you check up them numbers | 23:42 |
macyaway | I havent been on irc since about 9 years soon | 23:42 |
macyaway | Man i'm getting old and senile haha | 23:42 |
troal01 | http://geotool.servehttp.com/ | 23:43 |
troal01 | Just to help you out :) | 23:43 |
macyaway | nono, there used to be another site | 23:43 |
macyaway | Did it die? | 23:43 |
troal01 | Not sure, but that one is really good | 23:44 |
macyaway | Is it? | 23:45 |
macyaway | I will troll around some and i see if i find the old one .... oh im soooo tjurskallig | 23:45 |
troal01 | Well it pretty accurately picked out where I am :) | 23:45 |
troal01 | HAHAHA | 23:45 |
troal01 | Says you're in Vindeln, Vastebotten | 23:46 |
macyaway | no | 23:46 |
troal01 | Close? | 23:47 |
macyaway | you mean i? | 23:47 |
macyaway | Wöll .. you got me ... red handed ... good that it doesnt say i am on tvistevägen | 23:49 |
macyaway | it sais you are in canada nepean city and it is 18:48 .. region ontario | 23:49 |
macyaway | Do you want the latitude and longitude as well? | 23:49 |
macyaway | I got yer hostname as well .. oh if i would have known that i dont have to run the dns on yer host i could have just copied yer host :P | 23:50 |
troal01 | Hehehe, yeah that's pretty close... Not sure why it says Nepean though... It really is all Ottawa now a days | 23:51 |
macyaway | Prolly cuz it is a free software they dont update maps too often ;) | 23:52 |
macyaway | oh i just found out it is a demo of maxmind | 23:53 |
macyaway | prolly that is why it sucks :P | 23:53 |
troal01 | if you go to maxmind.com it does about the same search too | 23:55 |
macyaway | lipgeoip does the rest ... and you can do your manual queries on it | 23:56 |
macyaway | Oh i found this chick that is a super geek on sverige on the undernet | 23:57 |
macyaway | man she rocks | 23:57 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!