*** 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!