| *** grantc has joined #ingres | 00:10 | |
| *** ChanServ sets mode: +o grantc | 00:10 | |
| *** ii_log` is now known as ii_log | 00:38 | |
| pboro | Hmmh... I'm trying to dump a table into file for inserting it to a different system. The source table contains a bunch of varchars, and if I use "col = char(0)tab", the value in the copy file is padded with spaces | 00:59 |
|---|---|---|
| pboro | but it can't use varchar(0) either, 'cos then Ingres adds the length in the beginning of the value | 01:00 |
| pboro | so... fail :( | 01:04 |
| grantc | pboro: try http://www.dbforums.com/other/927555-ingres-unloading-simple-table-comma-delimited-file.html#post3408172 | 01:08 |
| pboro | yeah, I just used sed to trim the fields | 01:10 |
| pboro | should have remembered that copy to/from is only good for moving data between ingres installations :) | 01:10 |
| grantc | Alex|: congrats with getting Ingres into gentoo | 01:11 |
| Alex| | I'm working on an ebuild for v10... but it doesn't compile :( | 01:40 |
| Alex| | failed to build csmtmonitor.o | 01:49 |
| Alex| | and that leads to failing libcompat and the then rest is broken | 01:50 |
| grantc | why does csmtmonitor.o not build? | 01:54 |
| Alex| | it just says failed right after the call to cc... no error message | 01:55 |
| Alex| | even when I run the cc line manually I only see warnings, no errors... | 01:56 |
| grantc | am building on ubuntu 9.04 now - there appears to be a missing erglf.h | 01:59 |
| Alex| | ah no, there is indeed an error | 01:59 |
| Alex| | /usr/include/sys/select.h:85: error: previous declaration of 'fd_mask' was here | 01:59 |
| Alex| | Ingres is using a typedef for fd_mask which is already used by this system header | 02:02 |
| grantc | if you define "xCL_014_FD_SET_TYPE_EXISTS" does the problem go away? | 02:08 |
| Alex| | yes this is the problem... | 02:09 |
| Alex| | not sure where it gets defined | 02:11 |
| Alex| | there is a define in clconfig.h | 02:11 |
| Alex| | ah, tools/port/shell_unix/mksecret.sh:1682 | 02:15 |
| Alex| | $vers is int_lnx but fd_set is defined in select.h and not in types.h | 02:15 |
| Alex| | so the define is not set | 02:15 |
| Alex| | not sure what the sense of this if is... why not just always running the else part | 02:17 |
| grantc | perhaps it got over looked in some recent changes (last 3-4months) to the jam process | 02:19 |
| *** Gerhard has joined #ingres | 02:21 | |
| Alex| | is bugs being used? | 02:32 |
| grantc | yes | 02:33 |
| Alex| | ok, so I can put my patches there | 02:33 |
| *** FrankW has quit IRC | 04:01 | |
| *** Gerhard has quit IRC | 04:04 | |
| *** Dejan has joined #ingres | 04:40 | |
| Dejan | hello | 04:40 |
| *** Dejan is now known as Guest71125 | 04:40 | |
| Guest71125 | :) | 04:40 |
| *** Guest71125 is now known as Deyan | 04:40 | |
| Deyan | guys, i have a table with 4 rows | 04:41 |
| Deyan | one of them contains a single char | 04:41 |
| Deyan | H, L, M, C | 04:41 |
| Deyan | i want to select those rows and add additional column | 04:41 |
| Deyan | which will contain a number | 04:42 |
| Deyan | i used IF | 04:42 |
| Deyan | SELECT code, IF(code='H',3) FROM table | 04:42 |
| Deyan | can i have multiple IFs there? | 04:43 |
| Alex| | sounds like CASE | 04:43 |
| *** atrofast1 has quit IRC | 05:00 | |
| *** rossand has joined #ingres | 05:05 | |
| *** ChanServ sets mode: +o rossand | 05:05 | |
| *** cthibert has joined #ingres | 05:38 | |
| *** atrofast has joined #ingres | 05:39 | |
| *** Deyan is now known as Dejan | 06:32 | |
| *** mull_ has joined #ingres | 06:43 | |
| *** FrankW has joined #ingres | 06:57 | |
| *** Vroomfon1le has quit IRC | 07:18 | |
| *** Vroomfondle has joined #ingres | 07:18 | |
| *** cthibert has quit IRC | 07:45 | |
| *** FrankW has quit IRC | 07:51 | |
| *** atrofast has quit IRC | 07:54 | |
| *** atrofast has joined #ingres | 07:54 | |
| *** rossand has quit IRC | 08:00 | |
| Dejan | Alex|: yeah, it does ;) | 08:00 |
| *** Nornagest has quit IRC | 08:00 | |
| *** Alex| has quit IRC | 08:00 | |
| *** Alex| has joined #ingres | 08:01 | |
| *** ChanServ sets mode: +o Alex| | 08:01 | |
| *** Alex| is now known as Alex|off | 08:02 | |
| *** Nornagest has joined #ingres | 08:02 | |
| *** Alex|off is now known as Alex| | 08:03 | |
| *** toumi01 has joined #ingres | 08:09 | |
| *** FrankW has joined #ingres | 08:19 | |
| *** rossand has joined #ingres | 08:26 | |
| *** ChanServ sets mode: +o rossand | 08:26 | |
| *** cthibert has joined #ingres | 09:08 | |
| *** grantc has quit IRC | 10:12 | |
| cytrinox | E_US1914 APPEND: Sequence '`\u2013X`\u2013' referenced in next/current value was not found. | 10:39 |
| cytrinox | ..does anyone know what this message means? :) | 10:40 |
| pboro | you have some column set to get its value from a sequence and that sequence was not found? | 10:40 |
| pboro | at least that's how I understand it | 10:41 |
| Dejan | UTF ? | 10:42 |
| *** FrankW has quit IRC | 10:44 | |
| cytrinox | if this is utf-8, this is a very curious name for a sequence.. | 10:46 |
| Dejan | yep :D | 10:46 |
| Dejan | from my experience - ingres sometimes gets confused with sequences | 10:47 |
| cytrinox | I'm only use autogenerated sequences by GENERATED ALWAYS AS IDENTITY | 10:48 |
| cytrinox | uurgs | 10:48 |
| cytrinox | there is really such a sequence | 10:48 |
| cytrinox | looks like |||`X`||| | 10:48 |
| cytrinox | hmm.. seems i have found the next bug *grr* | 10:50 |
| pboro | cytrinox, which version of ingres? | 10:50 |
| cytrinox | 9.3 | 10:50 |
| cytrinox | the sequence was auto-generated from my create table "article"(... statement | 10:51 |
| cytrinox | my script tries now to delete the table, that triggers the deletion of the sequence and deleting a sequence with this same seems impossible :) | 10:51 |
| cytrinox | from visual dba i can't delete the sequence via context-menu/delete, too | 10:52 |
| cytrinox | drop sequence cytrinox..`-.X`-.. | 10:53 |
| cytrinox | E_US0A94 line 1, Unexpected character ''. | 10:53 |
| cytrinox | soo eh... how can i delete the table (and the sequence)? :) | 10:56 |
| pboro | you could try copydb on the db to see how ingres names the table and sequence in copy.out/in script | 10:57 |
| pboro | and then use that name in isql or similar to delete them | 10:57 |
| Dejan | cytrinox: then i am not surprised you have problems | 10:58 |
| Dejan | cytrinox: which version of ingres? | 10:58 |
| Dejan | 9.3 and above? | 10:58 |
| cytrinox | Dejan: 9.3 | 10:58 |
| Dejan | yeah... | 10:58 |
| Dejan | how many tables? | 10:58 |
| pboro | cytrinox, is it community version or the commercial version? | 10:59 |
| cytrinox | pboro: the name is totally fucked up, it contains non-printable chars. so I think I can't use any direct DROP SEQUENCE xxx; statement | 11:00 |
| pboro | okay, doh :( | 11:00 |
| cytrinox | Dejan: 2 tables I have just created | 11:00 |
| cytrinox | pboro: uhm.. it's the demo version which is available from the ingres.com page | 11:00 |
| pboro | cytrinox, ah, ok | 11:01 |
| Dejan | cytrinox: could it be that you did not properly escape those chars? | 11:03 |
| Dejan | or, could it be that you did not create database with unicode in mind? | 11:03 |
| pboro | cytrinox, what is the name of the table? | 11:03 |
| Dejan | IDENTITY column will autogenerate sequence behind the scene | 11:03 |
| pboro | just wondering about the name of the sequence... | 11:03 |
| cytrinox | Dejan: it's the demodb database that was available after installation | 11:03 |
| Dejan | name of the sequence should be in "help table <tablename>" | 11:04 |
| Dejan | (autogenerated for the INDENTITY field) | 11:04 |
| Dejan | sure | 11:05 |
| cytrinox | Dejan: I have executed my table-create script yestermay very often again and again to test some issues with stored procedures in ingres. | 11:05 |
| Dejan | you can always get it via "select * from iisequences" | 11:05 |
| Dejan | cytrinox: try to see if you have many locks | 11:06 |
| Dejan | i had to increase number of locks because by db got borked after a while | 11:07 |
| Dejan | grantc helped me, and we found that increase of locks can help | 11:07 |
| Dejan | something like: iisetres ii.*.rcp.lock.per_tx_limit 2000 | 11:07 |
| cytrinox | Dejan: a select on iisequences returns something like \f'\0x23.... | 11:08 |
| Dejan | what? | 11:08 |
| Dejan | o.O | 11:08 |
| cytrinox | wait, i take a screenshot :P | 11:08 |
| Dejan | that is weird | 11:08 |
| pboro | cytrinox, did you use other chars than those in ascii or iso8859-1 in the table names?-) | 11:08 |
| Dejan | either that, pboro, or he does not have terminal | 11:09 |
| Dejan | capable of showing special chars | 11:09 |
| Dejan | needed for TM | 11:09 |
| Dejan | well, screenshot will help | 11:09 |
| cytrinox | pboro: noo, I havn't do anything other from that what I have done yesteray 100000 times | 11:10 |
| pboro | ok | 11:10 |
| cytrinox | http://terminal.io/ingres1.png | 11:11 |
| cytrinox | the selected sequence is.. you will see it ;) | 11:11 |
| pboro | nice :D | 11:12 |
| cytrinox | this sequence is used by the article table. the user table uses the $iidentity_sequence_xxxxx | 11:12 |
| Dejan | khm... | 11:12 |
| Dejan | can you check for which table is it used | 11:12 |
| cytrinox | < cytrinox> this sequence is used by the article table. | 11:13 |
| Dejan | yeah, those are typically assigned for IDENTITY columns | 11:13 |
| Dejan | the problematic sequence is used for something else | 11:13 |
| Dejan | can you check which table is associated with it? | 11:13 |
| cytrinox | an again: < cytrinox> this sequence is used by the article table. | 11:13 |
| cytrinox | :) | 11:13 |
| cytrinox | you can see the create table script in the background window | 11:14 |
| Dejan | ups | 11:14 |
| cytrinox | ;) | 11:14 |
| cytrinox | If I want to drop the "article" table, ingres tells me it can't delete teh table because drop sequence \x(/&"8XX as a syntax error | 11:15 |
| Dejan | weiiird | 11:15 |
| cytrinox | jeeep :) | 11:15 |
| Dejan | i never used visual sql... | 11:15 |
| cytrinox | I'm using now ingres for two days.. two bugs in two days, maybe I should become a beta tester :-) | 11:15 |
| pboro | something went really wrong when the sequence was created... :D | 11:15 |
| Dejan | i use squirrel-sql on winblows | 11:15 |
| Dejan | and terminal monitor on linux | 11:15 |
| Dejan | cytrinox: i know the feeling | 11:16 |
| Dejan | i have already submitted 1 bug | 11:16 |
| Dejan | can you try to use command line utility? | 11:16 |
| Dejan | (terminal monitor) | 11:16 |
| Dejan | i see you are using some unix there | 11:17 |
| Dejan | why using visual sql... | 11:17 |
| Dejan | blasphemy! | 11:17 |
| Dejan | :))) | 11:17 |
| cytrinox | because I don't want to install anything outside of the virtual machine ;) | 11:18 |
| cytrinox | The initial idea was to include ingres in an article over stored procedure I'm currently writing on. I don't need any productive ingres system | 11:19 |
| cytrinox | I have switched to another db, now the script works | 11:20 |
| cytrinox | soo.. I'm using SELECT x INTO :myvar FROM y; inside my procedure. but that is broken in 9.3 | 11:22 |
| cytrinox | is there a second method to assign vars? | 11:23 |
| cytrinox | something like myvar = (SELECT...)? | 11:23 |
| pboro | lemme check the manual | 11:23 |
| pboro | hmmh... can't spot stored procedures in the manual... :D I guess I'm looking from the wrong places | 11:25 |
| cytrinox | hehe | 11:25 |
| pboro | ha, found it | 11:27 |
| pboro | "SELECT c_name, c_zip INTO :custname, :custzip FROM customer WHERE c_id = :custno;" | 11:29 |
| pboro | can't spot alternate syntax | 11:30 |
| pboro | what was the problem with the syntax, error is reported? | 11:30 |
| *** Dejan has quit IRC | 11:30 | |
| cytrinox | no, but such statements breaks selectable procedures | 11:31 |
| cytrinox | http://community.ingres.com/forum/questions-feedback-suggestions/11240-selectable-procedure-returns-no-rows.html | 11:31 |
| cytrinox | see last post | 11:31 |
| pboro | ok, thanks for the info | 11:31 |
| pboro | ahh, yes... unfortunately | 11:33 |
| pboro | oops, *unfortunate | 11:33 |
| cytrinox | jep | 11:34 |
| cytrinox | [...]If you replace both of these selects with an assignment statement that assigns the variable that's being assigned in the select statement, then the select from the table procedure runs. | 11:35 |
| cytrinox | I thought about var = SELECT .... | 11:36 |
| cytrinox | but that doesn't work | 11:36 |
| pboro | you could ask for an example from the forum, I can't spot any alternative syntax :/ | 11:38 |
| cytrinox | yeah, that is what i will try next :) | 11:39 |
| cytrinox | oh and.. I have asked on the forum but noone answered - I have a bug ID, but on bugs.ingres.com there isn't any bug with tis ID. is there a second bugtracker? | 11:40 |
| pboro | yes, it is an internal bug tracker used by Ingres Corp. | 11:41 |
| cytrinox | grml. | 11:41 |
| cytrinox | is there any chance to get an notice when the bug is closed/fixed? | 11:45 |
| pboro | if you're a paying customer, then yes | 11:46 |
| cytrinox | ... | 11:47 |
| pboro | hmm I guess that if the bug was logged at bugs.ingres.com, the guys at ingres would close it once fixed | 11:47 |
| pboro | but don't really know :) | 11:48 |
| pboro | considering the amount of bugs in Ingres, it's a saviour that the support service is so good | 11:49 |
| *** rossand has quit IRC | 11:54 | |
| *** rossand has joined #ingres | 11:57 | |
| *** ChanServ sets mode: +o rossand | 11:57 | |
| *** FrankW has joined #ingres | 12:03 | |
| *** mull_ is now known as mull | 13:05 | |
| *** toumi01 has quit IRC | 13:51 | |
| *** cthibert has left #ingres | 14:16 | |
| *** rossand has quit IRC | 14:50 | |
| *** mull has quit IRC | 14:58 | |
| *** rossand has joined #ingres | 15:46 | |
| *** ChanServ sets mode: +o rossand | 15:46 | |
| *** atrofast has quit IRC | 16:09 | |
| *** cytrinox_ has joined #ingres | 19:20 | |
| *** cytrinox has quit IRC | 19:21 | |
| *** cytrinox_ is now known as cytrinox | 19:21 | |
| *** toumi01 has joined #ingres | 19:28 | |
| *** toumi01 has left #ingres | 19:32 | |
| *** rossand has quit IRC | 21:15 | |
| *** Alex| has quit IRC | 23:34 | |
| *** Nornagest has quit IRC | 23:34 | |
| *** Alex| has joined #ingres | 23:35 | |
| *** ChanServ sets mode: +o Alex| | 23:35 | |
| *** Nornagest has joined #ingres | 23:36 | |
| *** Alex| is now known as Alex|off | 23:36 | |
| *** Alex|off is now known as Alex| | 23:36 | |
| *** grantc has joined #ingres | 23:45 | |
| *** ChanServ sets mode: +o grantc | 23:45 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!
