| *** Alex|off is now known as Alex| | 00:24 | |
| Deyan | meep | 01:14 |
|---|---|---|
| *** dyki has joined #ingres | 02:51 | |
| *** Deyan has quit IRC | 02:58 | |
| *** Deyan has joined #ingres | 03:56 | |
| Deyan | i am trying to shut down the server | 04:02 |
| Deyan | Waiting for the logging system to shut down ... | 04:02 |
| Deyan | and nothing | 04:02 |
| Deyan | freezes there | 04:02 |
| Alex| | without knowing if this may break something I would cancel ingstop and retry it with -f (force) or -k (kill) | 04:03 |
| Deyan | i tried -f | 04:03 |
| Alex| | -k is more - convincing... after that, kill -9 maybe the only thing left | 04:04 |
| Deyan | still the same... | 04:04 |
| Deyan | i think i will kill it | 04:05 |
| Alex| | I can't recommend that officially as it may lead to inconsistency but I don't know what else would help | 04:05 |
| Deyan | me neither | 04:06 |
| Deyan | it is for testing anyway | 04:06 |
| *** Alex| is now known as Alex|off | 05:32 | |
| *** DarylM has joined #ingres | 06:11 | |
| *** rossand has joined #ingres | 06:16 | |
| *** ChanServ sets mode: +o rossand | 06:16 | |
| *** mull has joined #ingres | 06:38 | |
| *** Alex|off is now known as Alex| | 06:40 | |
| Deyan | hello rossand | 06:43 |
| Deyan | and Alex| :) | 06:43 |
| *** Alex| is now known as Alex|off | 06:48 | |
| Deyan | do we have memory tables in Ingres? | 07:19 |
| toumi01 | temporary tables if they fit will be held in memory | 07:37 |
| Deyan | toumi01: good to know, thanks | 07:38 |
| Deyan | somehow MySQL way seems more natural to me - they have MEMORY as engine | 07:39 |
| Deyan | and it always go to memory | 07:40 |
| toumi01 | the MEMORY engine design sounds intuitive and very nice | 07:42 |
| toumi01 | but the Global Temporary Tables work well and after declaration (syntax is very different from regular tables) can be treated like tables | 07:43 |
| toumi01 | these tables are session-local and the GTT name space is like a different schema | 07:43 |
| Deyan | that is good to know | 07:44 |
| Deyan | toumi01: do you know if Ingres has "CONNECT BY" statement, like in Oracle? | 07:44 |
| Deyan | connect by is very useful for storing hierarchical data | 07:47 |
| Deyan | http://www.adp-gmbh.ch/ora/sql/connect_by.html | 07:47 |
| toumi01 | there is no CONNECT BY in Ingres | 07:50 |
| Deyan | ok | 07:51 |
| toumi01 | IIRC the O'Reilly SQL Cookbook gives vendor-specific syntax like this along with alternatives for other DBMSes | 07:51 |
| Deyan | i know how to do it "by hands" | 07:51 |
| Deyan | because i had to do it for MySQL long ago as well... | 07:52 |
| toumi01 | looks handy but also looks like a throwback to IMS and IDMS | 07:52 |
| toumi01 | maybe the hierarchical and networked DBMS vendors were onto something ;) | 07:53 |
| *** Deyan has quit IRC | 08:25 | |
| *** Alex|off is now known as Alex| | 10:17 | |
| dyki | \q | 10:33 |
| *** dyki has quit IRC | 10:33 | |
| *** Gerhard has joined #ingres | 12:36 | |
| *** joe_p has joined #ingres | 12:41 | |
| *** Nornagest has quit IRC | 12:42 | |
| *** [1]Gerhard has joined #ingres | 12:42 | |
| *** Nornagest has joined #ingres | 12:44 | |
| *** Gerhard has quit IRC | 12:49 | |
| *** [1]Gerhard is now known as Gerhard | 12:49 | |
| *** joe_p has left #ingres | 13:00 | |
| *** Gerhard has quit IRC | 13:24 | |
| *** Alex| is now known as Alex|off | 13:59 | |
| *** DarylM has quit IRC | 14:09 | |
| *** mull has quit IRC | 16:09 | |
| *** zxiiro has quit IRC | 16:12 | |
| *** zxiiro has joined #ingres | 16:13 | |
| *** ChanServ sets mode: +v zxiiro | 16:13 | |
| *** rossand has quit IRC | 17:07 | |
| *** mull has joined #ingres | 18:31 | |
| *** zxiiro has quit IRC | 19:16 | |
| *** zxiiro has joined #ingres | 19:20 | |
| *** ChanServ sets mode: +v zxiiro | 19:20 | |
| *** mull has quit IRC | 19:45 | |
| *** Alex|off is now known as Alex| | 22:36 | |
| *** Alex| is now known as Alex|off | 23:44 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!