*** grantc has joined #ingres | 00:26 | |
*** ChanServ sets mode: +o grantc | 00:26 | |
*** dyki has joined #ingres | 01:13 | |
*** atrofast has joined #ingres | 04:34 | |
*** atrofast has quit IRC | 04:48 | |
*** Dejan has joined #ingres | 05:57 | |
Dejan | hello everybody | 05:57 |
---|---|---|
*** rossand has joined #ingres | 06:06 | |
*** ChanServ sets mode: +o rossand | 06:06 | |
*** atrofast has joined #ingres | 06:14 | |
*** rossand has quit IRC | 06:28 | |
*** mull has joined #ingres | 06:29 | |
Dejan | guys, is there a statement that will just make a pause? | 06:37 |
*** atrofast has quit IRC | 06:37 | |
Alex| | is the database too fast? | 06:37 |
Alex| | can we have a reference story with you? | 06:37 |
*** atrofast has joined #ingres | 06:38 | |
Dejan | what you mean? | 06:53 |
Dejan | Alex|: it is related with the bug i submitted | 06:53 |
Dejan | i have hundreds of tables, and when i create them in a script, it generates too many locks | 06:53 |
Dejan | basically, copy.in sql code crashes the database | 06:54 |
Dejan | (system) | 06:54 |
Dejan | i need to put few breaks | 06:54 |
Dejan | i was thinking of splitting manually the copy.in into few chunks | 06:55 |
Dejan | and execute them one after another | 06:55 |
Alex| | I don't think there is such a thing as a sleep statement | 07:02 |
Dejan | what i did now is using split | 07:02 |
Dejan | i have splitted copy.in into files with ~5k lines of code | 07:02 |
Dejan | and i am executing them from a bash script | 07:03 |
Dejan | with 10sec pause between | 07:03 |
Dejan | if i execute whole copy.in DBMS crashes | 07:06 |
*** dyki has quit IRC | 07:08 | |
*** Dejan has quit IRC | 07:09 | |
*** toumi01 has left #ingres | 07:13 | |
*** Dejan has joined #ingres | 07:14 | |
* Dejan is back | 07:14 | |
*** toumi01 has joined #ingres | 07:15 | |
*** DarylM has joined #ingres | 07:17 | |
*** Dejan has quit IRC | 07:35 | |
atrofast | Anyone know why my Ingres build can't figure out libxerces, I get this message: don't know how to make <hb>libxerces-c.so.27.0 | 07:41 |
atrofast | It used to work | 07:41 |
grantc | i saw the same on my mac this morning - no idea why it's changed | 07:42 |
atrofast | This is a 64 bit system and I guess it's not picking up the 32 bit lib | 07:42 |
grantc | and the line before says /usr/local/src/.lib/lib....? | 07:43 |
atrofast | Well the reason I say that is because of this line: ...skipped /devsrc/geospatial/build/lib/lp32/libxerces-c.so.27.0 for lack of <hb>libxerces-c.so.27.0... | 07:43 |
grantc | i see "don't know how to make /usr/local/src/.libs/libxerces-c.2.8.dylib" | 07:47 |
atrofast | That's a weird one | 07:48 |
grantc | indeed | 07:48 |
atrofast | It seems happier if I export XERCVERS=28 instead of creating symlinks :P | 07:52 |
*** Alex| has quit IRC | 08:04 | |
atrofast | Both Ubuntu and Fedora are changing away from Pidgin to Empathy as default IM app with their new releases before the end of the year | 08:06 |
grantc | what's empathy like? and why the change? | 08:07 |
atrofast | Empathy is a front end to the Telepathy communications library | 08:09 |
atrofast | So I think the idea is that telepathy will support more protocols | 08:10 |
grantc | libpurple already supports lots of protocols - it underpins Adium on the Mac | 08:11 |
DarylM | Cool Telepathy. We won't even need any electronics. | 08:11 |
atrofast | Yeah true, well Fedora doesn't give a lot of info on the whys: https://fedoraproject.org/wiki/Features/Empathy | 08:11 |
atrofast | Haha | 08:11 |
atrofast | Found this on the Ubuntu wiki, it's a bit outdated: https://wiki.ubuntu.com/EmpathyVsPidginUsability | 08:16 |
atrofast | Seems like telepathy has support for voice and video which Pidgin does not | 08:17 |
*** Alex| has joined #ingres | 08:59 | |
*** ChanServ sets mode: +o Alex| | 08:59 | |
*** DerMeister has joined #ingres | 09:04 | |
*** Alex| has quit IRC | 09:59 | |
*** Alex| has joined #ingres | 10:00 | |
*** ChanServ sets mode: +o Alex| | 10:00 | |
*** atrofast has quit IRC | 10:18 | |
*** grantc has quit IRC | 11:10 | |
*** atrofast has joined #ingres | 11:19 | |
*** rilson has joined #ingres | 13:25 | |
rilson | hi guys, I'm trying to use the 'copy <table> from <file>' command to load a file into a table. I'm having problems to define the formar of the last field | 13:26 |
rilson | the column delimiter is '|' (pipe); in the last row I have for instance "... xxxxxx|<nl>", being <nl> a character representing a new line | 13:27 |
rilson | so I got an error when I do FIELD= char(0)'|'nl for the last field | 13:28 |
*** Alex| has quit IRC | 13:40 | |
*** DerMeister has quit IRC | 13:49 | |
*** rossand has joined #ingres | 14:27 | |
*** ChanServ sets mode: +o rossand | 14:27 | |
rilson | found a way: ... LAST_FIELD=char(0)'|',nl=d1) from ... | 14:57 |
*** FrankW has quit IRC | 15:07 | |
*** mull has quit IRC | 15:41 | |
*** rossand has quit IRC | 15:50 | |
*** rilson has quit IRC | 16:30 | |
*** FrankW has joined #ingres | 17:36 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:36 | |
*** cytrinox_ is now known as cytrinox | 19:36 | |
*** atrofast has quit IRC | 20:13 | |
*** mull has joined #ingres | 20:27 | |
*** rossand has joined #ingres | 20:38 | |
*** ChanServ sets mode: +o rossand | 20:38 | |
*** rossand has quit IRC | 21:03 | |
*** zxiiro is now known as zxiiro_ | 21:21 | |
*** zxiiro_ has left #ingres | 21:21 | |
*** rossand has joined #ingres | 22:05 | |
*** ChanServ sets mode: +o rossand | 22:05 | |
*** rossand has quit IRC | 22:18 | |
*** Alex| has joined #ingres | 22:34 | |
*** ChanServ sets mode: +o Alex| | 22:34 | |
*** Alex| has quit IRC | 23:11 | |
*** rossand has joined #ingres | 23:21 | |
*** ChanServ sets mode: +o rossand | 23:21 | |
*** Alex| has joined #ingres | 23:30 | |
*** ChanServ sets mode: +o Alex| | 23:30 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!