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