| *** dyki has joined #ingres | 02:32 | |
| *** Deyan has joined #ingres | 02:43 | |
| Deyan | woohoooo | 02:43 |
|---|---|---|
| Deyan | morning gents | 02:43 |
| *** Gerhard has joined #ingres | 03:57 | |
| Deyan | hi Gerhard | 04:06 |
| Gerhard | Hi Deyan | 04:15 |
| *** toumi01 has joined #ingres | 04:24 | |
| *** Gerhard has quit IRC | 04:51 | |
| Deyan | anyone using 9.3 in production? | 05:27 |
| Deyan | :) | 05:27 |
| *** micksale has joined #ingres | 05:59 | |
| *** micksale has quit IRC | 05:59 | |
| *** micksale has joined #ingres | 05:59 | |
| *** micksale has left #ingres | 05:59 | |
| *** rossand has joined #ingres | 06:21 | |
| *** ChanServ sets mode: +o rossand | 06:21 | |
| *** dyki has quit IRC | 06:37 | |
| *** atrofast has quit IRC | 06:37 | |
| *** Nornagest has quit IRC | 06:37 | |
| *** pboro has quit IRC | 06:37 | |
| *** magnusg| has quit IRC | 06:37 | |
| *** magnusg| has joined #ingres | 06:44 | |
| *** dyki has joined #ingres | 06:44 | |
| *** atrofast has joined #ingres | 06:44 | |
| *** Nornagest has joined #ingres | 06:44 | |
| *** pboro has joined #ingres | 06:44 | |
| *** withdefault has joined #ingres | 07:01 | |
| *** ChanServ sets mode: +o withdefault | 07:01 | |
| *** DerMeister has joined #ingres | 07:03 | |
| * Deyan is installing ingres 10 | 07:05 | |
| Deyan | helmets on! | 07:05 |
| *** thiagomz has joined #ingres | 07:05 | |
| Deyan | haha | 07:05 |
| thiagomz | Guys, how can I identify what is the table_name ==> KEY(PAGE,DB=4A272087,TABLE=[4006,0],PAGE=18889) | 07:06 |
| magnusg| | thiagomz, You need to connect to the database where the table is (if you don't know which it is you can use 4A272087 to identify it). Then do a select table_name from iitables where table_reltid = 4006 and table_reltidx = 0 | 07:09 |
| thiagomz | magnusg|: tkz | 07:10 |
| magnusg| | If the second table is 0 then it is a base table and not an index | 07:10 |
| magnusg| | The second number | 07:10 |
| thiagomz | okz | 07:11 |
| thiagomz | magnusg|: 0 rows | 07:13 |
| thiagomz | where can i identify the database name with 4A272087 ? | 07:13 |
| thiagomz | magnusg|: tkz, worked | 07:15 |
| magnusg| | I was afraid of that question - I've always known which database to look in :-). I think it is a hex format of the db_id in the iidatabase table of iidbdb. | 07:17 |
| magnusg| | Yes, I verified that. | 07:19 |
| *** Deyan has quit IRC | 07:20 | |
| thiagomz | ;) | 07:25 |
| thiagomz | are there a way to identify what lines are in a page ? | 07:25 |
| thiagomz | rows... | 07:26 |
| magnusg| | Yes | 07:26 |
| magnusg| | But I don't have the formula in my head. A the page number can be identified by tid/512 (Tuple ID) | 07:28 |
| magnusg| | Someone else? | 07:28 |
| *** FrankW has joined #ingres | 07:29 | |
| magnusg| | It is possible that select * from qq where tid > 23*512 and tid < 24*512 will give you the rows of page 23 but I haven't verified it and unfortunately I have to go now. | 07:35 |
| magnusg| | It should be where tid >= 23*512 BTW as the tid of the first row of page 23 is exactly 23*512 IIRC. | 07:37 |
| *** magnusg| has left #ingres | 07:38 | |
| *** Alex| is now known as Alex|off | 07:43 | |
| thiagomz | i will try | 07:44 |
| *** FrankW has quit IRC | 08:45 | |
| dyki | does anybody know if the permissions or something regarding reloading databases have changed since 9.4 -> 10.0 ? | 08:58 |
| dyki | i have unloaded dbs from 9.4 that worked fine, tried on most recent 10, reloading is successful, but tables are not accessible. | 08:59 |
| dyki | usual message "does not exist of is not owed by you" appears. | 08:59 |
| *** FrankW has joined #ingres | 09:43 | |
| *** Alex|off is now known as Alex| | 09:46 | |
| *** Alex| is now known as Alex|off | 10:02 | |
| *** rossand has quit IRC | 10:04 | |
| *** mull has joined #ingres | 10:10 | |
| *** withdefault1 has joined #ingres | 10:14 | |
| *** withdefault has quit IRC | 10:17 | |
| *** dyki has quit IRC | 10:18 | |
| *** withdefault1 has quit IRC | 10:20 | |
| *** withdefault has joined #ingres | 11:12 | |
| *** ChanServ sets mode: +o withdefault | 11:12 | |
| FrankW | I wanted to mention I was successful thursday night on the ingres spatial branch build. Now, I'm digging into how to install the built DB, setup an instance and experiment a bit with the spatial capabilities. | 11:37 |
| pboro | FrankW, congrats :) | 11:53 |
| atrofast | FrankW: from $ING_ROOT (where runbuild.sh is) just do buildtools/createdbms <Instance ID> | 12:20 |
| FrankW | I have that, and I did createdb to create a particular database. | 12:21 |
| FrankW | Now I'm reading the online docs to learn about the sql command a bit, and I hope to find some kinds on testing spatial somewhere. | 12:21 |
| FrankW | A pity that the Ingres Trac instance is not integrated with subversion instance. There are a lot of nice attributes to having these connected. | 12:51 |
| FrankW | I was hoping to explore commits that have been made on the geospatial branch, but I'm not so sure how to do that nicely directly against subversion. | 12:51 |
| pboro | FrankW, yeah, that's something I like too | 12:55 |
| *** atrofast1 has joined #ingres | 13:15 | |
| *** pboro has quit IRC | 13:16 | |
| *** pboro has joined #ingres | 13:16 | |
| *** atrofast has quit IRC | 13:33 | |
| *** withdefault has quit IRC | 14:48 | |
| *** DerMeister has quit IRC | 14:49 | |
| atrofast1 | FrankW: Trac should be integrated with SVN, you might have to log in to see everything though (just use your svn account) | 15:09 |
| *** mull has quit IRC | 15:27 | |
| *** rossand has joined #ingres | 16:38 | |
| *** ChanServ sets mode: +o rossand | 16:38 | |
| *** rossand has quit IRC | 16:55 | |
| *** toumi01 has left #ingres | 18:13 | |
| FrankW | atrofast1: you are quite right! | 18:26 |
| *** rossand has joined #ingres | 18:50 | |
| *** ChanServ sets mode: +o rossand | 18:50 | |
| *** rossand has quit IRC | 20:24 | |
| *** Alex|off is now known as Alex| | 22:15 | |
| *** Alex| is now known as Alex|off | 22:52 | |
| *** Alex|off is now known as Alex| | 23:06 | |
| *** magnusg| has joined #ingres | 23:28 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!