pboro | ah... I got bug 119283 reproduced on 9.2 | 01:07 |
---|---|---|
*** Deyan has joined #ingres | 02:50 | |
Deyan | hello | 02:50 |
pboro | Hi Deyan | 02:51 |
pboro | http://community.ingres.com/forum/questions-feedback-suggestions/10900-ingres-t-shirt.html | 02:51 |
pboro | damn, that would be cool | 02:51 |
pboro | nerds usually wear product t-shirts etc. so it would work nicely work Ingres too :> | 02:52 |
Deyan | yeah, i have already ordered it | 02:59 |
Deyan | pboro: i have a noob question for you | 02:59 |
Deyan | i have noticed the TID field | 02:59 |
Deyan | today | 02:59 |
Deyan | is that some sort of primary key in the table? | 02:59 |
Deyan | i understand it is perhaps used behind the scenes to perform relational algebra on tuples | 02:59 |
pboro | TIDs are tuple identifiers or row addresses | 03:00 |
Deyan | i typically have something like: tablename_id INTEGER in almost every table | 03:00 |
Deyan | which is my primary key | 03:00 |
Deyan | can i use TID for that? | 03:01 |
pboro | no I would not recommend doing that | 03:01 |
pboro | TIDs may change, they are only meant for DBMS... you need your own key for your own purposes | 03:01 |
Deyan | ahaaaa | 03:01 |
Deyan | i did not think about that! | 03:01 |
Deyan | good point | 03:01 |
pboro | This is a bit outdated by the idea is the same today: The TID contains the page number and the index of the offset to the row relative to the page boundary. TIDs are presently implemented as 4-byte integers. The TID uniquely identifies each row in a table. Every row has a TID. The high-order 23 bits of the TID are the page number of the page in which the row occurs. The TID can be addressed in SQL by the name 'tid'. | 03:02 |
Deyan | yeppers | 03:03 |
Deyan | i have already done some stuff using TIDs | 03:03 |
Deyan | just for testing | 03:03 |
Deyan | pboro: thanks for information mate | 03:04 |
Deyan | i appreciate it | 03:04 |
pboro | no prob :) | 03:04 |
Deyan | i am asking because i am doing a major redesign of a huge database | 03:04 |
Deyan | and i typically added primary keys | 03:04 |
Deyan | in fashion i described above | 03:04 |
pboro | there were none before? | 03:04 |
Deyan | do not ask... | 03:04 |
Deyan | :) | 03:04 |
Deyan | yeah, most tables did not have PKs :))) | 03:05 |
pboro | hehe :) that's the history here too | 03:05 |
Deyan | pboro: welcome to the dark side :D | 03:05 |
pboro | I have done huge work in adding proper indexes etc. into our legacy databases... | 03:05 |
Deyan | well, we had some indices... | 03:05 |
Deyan | in our legacy database | 03:06 |
Alex| | regarding the use of the Ingres logo... I think the logo itself is not trademarked - only the name.. so the TM would be wrong anyway... | 03:06 |
Deyan | however, most of tables did not have any primary keys | 03:06 |
Deyan | really? | 03:06 |
Deyan | ty Alex | 03:06 |
Deyan | i will remove TM from there | 03:06 |
pboro | Alex|, TM even doesn't mean it's registered, (R) does. TM is something that anyone can add to their logo or name when trying to get ownership of it | 03:07 |
pboro | usually most logos and names are TM until they are registered, when it becomes (R) | 03:07 |
Alex| | ah ok... we had an (R) in the logo for a while and had to remove it | 03:07 |
Deyan | well, i suppose Ingres Inc is the owner of that logo? | 03:07 |
Deyan | well, that is what i guessed | 03:07 |
Deyan | did not know it is not | 03:08 |
Alex| | no idea... marketing will know I hope | 03:08 |
*** dyki has joined #ingres | 03:08 | |
Deyan | dyki \o/ | 03:08 |
Alex| | I just know that my business card no longer has the (R) on the logo :) | 03:08 |
pboro | oh, weird :-o | 03:09 |
pboro | Alex|, http://en.wikipedia.org/wiki/Trademark | 03:10 |
pboro | maybe Ingres Corp. has not registered it and (R) was put in mistake | 03:10 |
dyki | did that change after CA abandoned Ingres? | 03:10 |
Alex| | don't know | 03:11 |
pboro | "Ingres" is owned by... "(REGISTRANT) Ingres Corporation CORPORATION DELAWARE 1080 Marina Village Parkway Alameda CALIFORNIA 94501" | 03:11 |
pboro | http://tess2.uspto.gov/bin/gate.exe?f=searchss&state=4004:sbosno.1.1 and just type Ingres and search :) | 03:12 |
Alex| | the name - but the logo? | 03:12 |
pboro | you can use (R) for the logo too but it must then only refer to the name... I don't know if it's possible to search logos anywere :/ | 03:13 |
pboro | ah, it says "Typed Drawing" | 03:13 |
Alex| | ah | 03:13 |
pboro | so it means the name as in certain form | 03:13 |
Alex| | and in the form it was in 1992 and at Alamada :) | 03:17 |
pboro | hmm should it be possible to investigate core dump from iidbms with gdb? | 03:32 |
pboro | #9 0x00588290 in adc_compare () | 03:32 |
pboro | #10 0x005afba8 in adt_compare () | 03:32 |
pboro | I'm missing some data, Ingres is prolly not compiled with debugging? | 03:33 |
Alex| | not the releases, no... you'd need to compile it yourself | 03:33 |
pboro | damn... | 03:33 |
pboro | #8 0x00000000 in ?? () | 03:34 |
pboro | #9 0x00588290 in adc_compare () | 03:34 |
pboro | #10 0x005afba8 in adt_compare () | 03:34 |
pboro | "If the routine does run across a datatype that is not in this list, it will call the general routine "adc_compare()", thereby guaranteeing that it will function (perhaps slower), for ALL datatypes, even future user defined ADTs." | 03:35 |
pboro | I wonder what gets passed to adt_compare :/ | 03:35 |
Deyan | looks like 9.4 is bugged | 04:02 |
Deyan | :) | 04:02 |
Deyan | i am trying to copy table from a file | 04:03 |
Deyan | and it goes over the actual amount of rows | 04:03 |
Deyan | "E_CO0024 COPY: Unexpected END OF FILE while processing row 3813." | 04:03 |
Deyan | and i have 3735 rows in it :D | 04:03 |
pboro | well yeah, 9.4 is still under heavy development | 04:03 |
pboro | latest production release is 9.2 | 04:03 |
dyki | Deyan: I have the same issue here! | 04:05 |
Deyan | really? | 04:06 |
Deyan | o.O | 04:06 |
dyki | yeah.. | 04:06 |
dyki | I think I might go back to 9.3 | 04:07 |
Deyan | good idea | 04:08 |
*** grantc has joined #ingres | 04:41 | |
*** ChanServ sets mode: +o grantc | 04:41 | |
Deyan | hey grantc \o/ | 04:41 |
grantc | morning all | 04:41 |
grantc | hi Deyan | 04:42 |
dyki | afternoon :) | 04:42 |
grantc | Deyan: regarding getting DBjmin working with Ingres you will need to hack the source code | 04:42 |
Deyan | aha, okay | 04:43 |
grantc | not much work from what i saw but i am no java developer | 04:43 |
Deyan | i am using razorsql anyway | 04:43 |
Deyan | just wanted to try that dbjmin proggy | 04:43 |
grantc | dbvisualizer is quite good | 04:46 |
* Deyan thinks ingres should switch to CMake | 04:49 | |
Deyan | :D | 04:50 |
Alex| | go ahead | 04:50 |
Alex| | I was told by some ppl "this can't be too hard to do"... never heard of them anymore | 04:51 |
pboro | :DDD | 04:51 |
Deyan | Alex|: i do not say it will be easy | 04:51 |
Deyan | :) | 04:51 |
Deyan | i saw the src structure | 04:52 |
Deyan | it is huge | 04:52 |
Alex| | some Ingres devs say the jam files aren't that hard to understand and overlook... I never believed them. | 04:53 |
Alex| | I managed to add a few things to them without breaking anything - that's the best I could do | 04:54 |
Deyan | can i somehow easily make the current build system to just build database-related components? | 05:13 |
Alex| | not easily... you'd have to remove them from the jamfiles without breaking dependencies | 05:17 |
*** Deyan has quit IRC | 05:46 | |
*** Deyan has joined #ingres | 05:52 | |
* Deyan is back | 05:52 | |
thiagomz | guys... why it doesn´t work ? statdump -zc iidbdb | 05:53 |
thiagomz | optimizedb -zk -zu200 -zr200 -u'$ingres' iidbdb -riidbdepends | 06:13 |
thiagomz | worked | 06:13 |
*** Alex| is now known as Alex|off | 06:21 | |
thiagomz | guys, how does you optimize iidbdb ? i mean command | 07:06 |
thiagomz | i have 104 without stats... | 07:06 |
thiagomz | on iidbdb | 07:06 |
thiagomz | i thing that is bad | 07:07 |
thiagomz | or not ? | 07:07 |
*** Alex|off is now known as Alex| | 07:16 | |
*** rossand has joined #ingres | 07:21 | |
*** ChanServ sets mode: +o rossand | 07:21 | |
*** Alex| is now known as Alex|off | 07:37 | |
*** rossand has quit IRC | 08:01 | |
*** DerMeister has joined #ingres | 09:52 | |
*** dyki has quit IRC | 09:59 | |
*** Deyan has quit IRC | 10:01 | |
*** Alex|off is now known as Alex| | 10:34 | |
*** grantc has quit IRC | 10:45 | |
*** withdefault has quit IRC | 12:21 | |
*** Alex| has quit IRC | 12:29 | |
*** Alex| has joined #ingres | 12:29 | |
*** ChanServ sets mode: +o Alex| | 12:30 | |
*** Alex| has quit IRC | 13:32 | |
*** Nornagest has quit IRC | 13:32 | |
*** Alex|off has joined #ingres | 13:33 | |
*** Alex|off is now known as Alex| | 13:34 | |
*** Nornagest has joined #ingres | 13:34 | |
*** ChanServ sets mode: +o Alex| | 13:34 | |
*** Alex| is now known as Alex|off | 13:42 | |
*** DerMeister has quit IRC | 14:14 | |
*** chenzhen has joined #ingres | 20:11 | |
*** chenzhen has left #ingres | 20:12 | |
*** chenzhen has joined #ingres | 20:12 | |
*** zxiiro has joined #ingres | 20:18 | |
*** zxiiro has left #ingres | 20:19 | |
*** rossand has joined #ingres | 20:20 | |
*** ChanServ sets mode: +o rossand | 20:20 | |
*** rossand has quit IRC | 20:41 | |
*** chenzhen has left #ingres | 21:23 | |
*** Alex|off is now known as Alex| | 22:05 | |
*** toumi01 has quit IRC | 22:23 | |
*** Alex| is now known as Alex|off | 22:51 | |
*** Alex|off is now known as Alex| | 23:06 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!