*** gerhard has joined #ingres | 00:21 | |
gerhard | Hi all | 00:24 |
---|---|---|
*** gerhard has quit IRC | 01:13 | |
*** Mud|game has joined #ingres | 01:19 | |
*** Mud|game is now known as Mud | 01:19 | |
*** KermitTheFragger has joined #ingres | 01:28 | |
*** PaulM05 has joined #ingres | 01:30 | |
pboro | hmh, community.ingres.com seems to be broken | 02:24 |
pboro | oops, I mean the wiki part | 02:25 |
pboro | just getting blank page: http://community.ingres.com/wiki/ | 02:25 |
Vroomfondle | ingres.com looks a bit broken in general to me | 02:28 |
Vroomfondle | I'm sitting here waiting for docs.ingres and esd.ingres to load | 02:28 |
Alex| | there was heavy load on apache... I've restarted it now | 02:30 |
pboro | wiki still giving blank | 02:30 |
Alex| | I see it :( | 02:30 |
Vroomfondle | Alex|: ah yeah, working now | 02:31 |
KermitTheFragger | hi all | 02:32 |
Alex| | still all very slow | 02:32 |
KermitTheFragger | i've got a question about identities | 02:32 |
KermitTheFragger | if you use something like GENERATED BY DEFAULT | 02:32 |
KermitTheFragger | is there a standard way of 'finding' the sequence that ingres created for that table ? | 02:33 |
KermitTheFragger | for example to get the current val | 02:33 |
Alex| | not sure what's with the wiki... nothing in the log | 02:34 |
pboro | ah, wiki works now | 02:34 |
pboro | for now :) | 02:34 |
Alex| | it does? ok, I still get a blank page | 02:35 |
pboro | try force reload | 02:35 |
Alex| | yeah, that helped... ok. | 02:35 |
Alex| | looked like a bot, DoS or something that brought apache down | 02:36 |
pboro | thanks mate | 02:36 |
PaulM05 | Kermit: - HELP DEFAULT mytable - should show the defaults for the table, which in the case of an identity will name the sequence | 02:51 |
PaulM05 | if you access the sequence directly you'll need double quotes around it as it starts with a $ e.g. SELECT "$iiidentity_sequence_0000250".CURRVAL | 02:52 |
KermitTheFragger | PaulM05: thx | 02:53 |
KermitTheFragger | do you know if there is something similar to SELECT LAST_INSERT_ID() in MySQL or VALUES IDENTITY_VAL_LOCAL() in DB 2 ? | 02:53 |
PaulM05 | does look like it | 02:56 |
PaulM05 | doesn't | 02:56 |
KermitTheFragger | PaulM05: do you know if there is any 'logic' in the sequence names ? | 02:58 |
KermitTheFragger | like in postgresql, where its tablename_columnname_seq ? | 02:58 |
PaulM05 | looks like a generated number | 02:58 |
KermitTheFragger | in ingres all i see is a number i can't really trace | 02:58 |
KermitTheFragger | hmm i guess that would require me to specify the sequence name when i create the column | 03:00 |
PaulM05 | there will be a way to trace it via the system catalogs | 03:02 |
PaulM05 | just having a root around now | 03:03 |
PaulM05 | iicolumns.column_default_val has the string that's output in HELP DEFAULT - but you'd need to parse that a little - not sure if we store just the name | 03:06 |
KermitTheFragger | PaulM05: thx, ill experiment with that | 03:09 |
*** grantc has joined #ingres | 03:12 | |
*** cthibert has joined #ingres | 03:35 | |
*** Mud has quit IRC | 03:43 | |
*** Mud has joined #ingres | 03:48 | |
*** zxiiro has quit IRC | 05:02 | |
*** PaulM05 is now known as PaulM05_lunch | 05:06 | |
*** mull has quit IRC | 05:13 | |
*** zxiiro has joined #ingres | 05:42 | |
*** ChanServ sets mode: +v zxiiro | 05:42 | |
*** Alex| has quit IRC | 05:49 | |
*** mull has joined #ingres | 06:01 | |
*** PaulM05_lunch is now known as PaulM05 | 06:04 | |
*** rossand has joined #ingres | 06:57 | |
*** ChanServ sets mode: +o rossand | 06:57 | |
*** cthibert has left #ingres | 07:21 | |
*** Mud has quit IRC | 07:42 | |
*** Mud has joined #ingres | 07:47 | |
*** cthibert has joined #ingres | 07:54 | |
*** Mud has quit IRC | 07:54 | |
*** Alex| has joined #ingres | 08:20 | |
*** ChanServ sets mode: +o Alex| | 08:20 | |
*** dyki has joined #ingres | 09:12 | |
*** cthibert has left #ingres | 09:13 | |
*** atrofast has joined #ingres | 09:22 | |
*** PaulM05 has quit IRC | 09:44 | |
*** KermitTheFragger has quit IRC | 09:58 | |
*** grantc has quit IRC | 10:20 | |
*** Mud|game has joined #ingres | 10:49 | |
*** Mud|game is now known as Mud | 10:50 | |
*** Mud has joined #ingres | 10:50 | |
*** toumi01 has joined #ingres | 11:21 | |
*** zxiiro has quit IRC | 11:38 | |
*** Mud has quit IRC | 11:42 | |
*** Mud has joined #ingres | 11:48 | |
*** zxiiro has joined #ingres | 11:54 | |
*** ChanServ sets mode: +v zxiiro | 11:54 | |
*** zxiiro has quit IRC | 11:58 | |
*** bonro01 has quit IRC | 12:20 | |
*** bonro01 has joined #ingres | 12:26 | |
*** cthibert has joined #ingres | 12:40 | |
*** dyki has quit IRC | 12:59 | |
*** rossand has quit IRC | 13:02 | |
*** zxiiro has joined #ingres | 13:44 | |
*** ChanServ sets mode: +v zxiiro | 13:44 | |
*** cthibert has left #ingres | 13:49 | |
*** atrofast_ has joined #ingres | 14:56 | |
*** Mud has quit IRC | 14:56 | |
*** atrofast has quit IRC | 14:56 | |
*** mull has quit IRC | 15:41 | |
*** DarylM has quit IRC | 15:55 | |
*** Alex| has quit IRC | 16:09 | |
*** atrofast_ has quit IRC | 16:25 | |
*** cytrinox has quit IRC | 19:23 | |
*** cytrinox has joined #ingres | 19:25 | |
*** Alex| has joined #ingres | 23:55 | |
*** ChanServ sets mode: +o Alex| | 23:55 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!