| *** rossand has quit IRC | 01:44 | |
| *** mc349 has quit IRC | 03:05 | |
| *** Alex|off is now known as Alex| | 07:05 | |
| *** notdefault is now known as withdefault | 07:09 | |
| *** grantc_offline is now known as grantc | 07:15 | |
| *** Alex| is now known as Alex|off | 07:42 | |
| pboro | hmm... is it possible to put newlines in SELECT? like... SELECT "User: " || TRIM(effective_user) || "\n" || "...? | 08:02 |
|---|---|---|
| pboro | Trying to write a simple sessions listing script | 08:03 |
| grantc | pboro, i believe so since people have used them to format "create proc" | 08:04 |
| pboro | I just have to figure out the syntax then... | 08:04 |
| pboro | hmmh, looks like sql/tm replaces the newline with "\n" in the output | 08:21 |
| pboro | insert into test values (?Hello world?+x?0a?); | 08:25 |
| pboro | that's from the manual... but it doesn't work :-o | 08:26 |
| pboro | http://docs.ingres.com/Ingres/9.2/SQL%20Reference%20Guide/terminalmonitorcharacterinputoutput.htm | 08:28 |
| pboro | does that work for someone? | 08:28 |
| pboro | ah, it does work in isql | 08:29 |
| pboro | and sql, but it converts it into \n when outputin :D | 08:29 |
| pboro | damnit... | 08:29 |
| grantc | perhaps its a bug? | 08:30 |
| pboro | I guess it's just a way how sql & isql works, they convert any \n into string \n in output instead of printing newline | 08:30 |
| pboro | I can replace those \n's with real \n's using sed, so... | 08:31 |
| pboro | err... sql/tm is too primitive for this, I guess I have to write a C program anyway | 08:34 |
| withdefault | you could write it in a scripting language that has an Ingres driver | 08:36 |
| pboro | I wanted to keep it simple (just a sh script), but it looks like I need to use Python or similar | 08:37 |
| pboro | I have never written a python script, maybe this is the day to begin :) | 08:38 |
| pboro | oh wait, wasn't there perl driver too | 08:38 |
| withdefault | yes - I've not used that before | 08:39 |
| grantc | pboro, yes there is but it's behind in terms of support for ingres compared to the other drivers | 08:39 |
| pboro | hm :/ I'll try the perl driver first to see if it's enough | 08:41 |
| pboro | dated 2004... oh well, Ingres isn't that new either | 08:41 |
| grantc | do you do stuff with unicode? | 08:42 |
| pboro | nope, I will just poke around imadb :) I'm creating some administrative scripts | 08:42 |
| grantc | i guess you should be fine there (unless you come across any bigints :)) | 08:43 |
| pboro | ah, Stefan Reddig has taken care of DBD-Ingres in 2008 and done some updates to the driver | 08:43 |
| pboro | http://search.cpan.org/dist/DBD-Ingres/ | 08:43 |
| grantc | yup - i see he fixed the 64 bit issue | 08:45 |
| pboro | quite a lot of compiler warnings for such a small program :D | 08:55 |
| grantc | i am sure he accepts patches :) | 08:56 |
| pboro | part of the code is generated from Ingres (.sc), I guess that's something that can't be fixed in the driver | 08:56 |
| grantc | perhaps | 08:57 |
| grantc | for those that know C, are there any alternatives to atoi() that are platform agnostic? | 09:09 |
| pboro | platform agnostic in what way? :) | 09:10 |
| withdefault | what's wrong with atoi()? | 09:10 |
| grantc | nothing at the moment | 09:10 |
| pboro | it's part of ISO C anyway | 09:10 |
| grantc | in that case it stays, I have not got as far as testing my code on windows/solaris | 09:11 |
| pboro | there are some problems with atoi tho', for example it doesn't provide any useful error indicators and it may not perform too well | 09:12 |
| grantc | this is code that only gets executed with an ini_set(), invoked from user land | 09:13 |
| pboro | okay, then the performance is not a question here :) | 09:13 |
| grantc | well kind of, i am replacing a conditional check on every ingres_query() with atoi() in ini_set... | 09:14 |
| pboro | oh... | 09:14 |
| grantc | http://lists.ingres.com/pipermail/ip-os-drivers/2009-February/000147.html3 | 09:14 |
| grantc | http://lists.ingres.com/pipermail/ip-os-drivers/2009-February/000147.html | 09:14 |
| grantc | even.. | 09:15 |
| grantc | if you pepper your PHP code with ini_set() then this code will get invoked but that's your problem so to speak | 09:19 |
| grantc | withdefault, the dynamic cache feature does it work with views? | 10:05 |
| withdefault | if the view is included in the query, then I don't see why not | 10:07 |
| grantc | ok thanks - there is some guy on twitter who is having some problems | 10:08 |
| withdefault | check if they're using prepared queries | 10:09 |
| grantc | yup, already there... | 10:09 |
| grantc | does hibernate use prepared queries by default? | 10:14 |
| withdefault | I think it does | 10:14 |
| grantc | ok - now to work out how to get him to enable cache dynamic in a tweet | 10:15 |
| *** bonro011 has joined #ingres | 11:33 | |
| *** bonro01 has quit IRC | 11:33 | |
| *** troal01 has joined #ingres | 11:54 | |
| *** troal01 has quit IRC | 11:57 | |
| *** troal01 has joined #ingres | 12:01 | |
| troal01 | ATI + Linux = bad combo | 12:01 |
| pboro | in some cases, yes :) | 12:06 |
| pboro | grantc, session_id in ima is bigint? :( | 12:25 |
| pboro | ah, no, it's just varchar(32) | 12:25 |
| grantc | i would have thought that some of the stats tables use i8 but it would appear not | 12:26 |
| grantc | perhaps the underlying types in ingres are i4 still? | 12:27 |
| pboro | they are varchars mostly :) | 12:27 |
| pboro | yeah prolly | 12:27 |
| grantc | for session id sure since it could be a hex val | 12:27 |
| pboro | in ima table it's integer | 12:28 |
| pboro | I need to do HEX() on it to get the hex value which is shown by IPM | 12:28 |
| grantc | ah there you go | 12:29 |
| pboro | integer in varchar column is funny, but doesn't matter here :) | 12:29 |
| pboro | Any tips what does "577" stand for in session string "1DFC8100:577"? | 12:30 |
| grantc | thread id? | 12:30 |
| pboro | could be... good tip, I'll check that | 12:30 |
| pboro | yeah, seems so since it's unique | 12:31 |
| troal01 | In Ingres I can do a CREATE TABLE AS SELECT correct, but is there anything that will MOVE the data from the old table to the new? | 12:37 |
| grantc | troal01, no | 12:37 |
| troal01 | AWw | 12:37 |
| grantc | if you are looking to rename a table, no, if you want to move sections of data no | 12:38 |
| grantc | the former could be done via hacking the system catalogs | 12:39 |
| troal01 | I'd rather not hack it | 12:39 |
| *** troal01 has quit IRC | 12:42 | |
| *** rossand has joined #ingres | 13:01 | |
| *** ChanServ sets mode: +o rossand | 13:01 | |
| *** rossand has quit IRC | 13:08 | |
| *** troal01 has joined #ingres | 13:17 | |
| *** rossand has joined #ingres | 13:20 | |
| *** ChanServ sets mode: +o rossand | 13:20 | |
| pboro | E_US1400 Natural join syntax is not yet supported. | 13:38 |
| pboro | doh :D | 13:38 |
| troal01 | Blah I can't re-enable desktop effects... Something is off with my ATI drivers I think | 13:54 |
| troal01 | It used to work | 13:54 |
| pboro | Here's something I quickly wrote on my coffee break: http://pauli.borodulin.fi/misc/ingres/ima_sessions-v1.0.pl | 14:07 |
| *** mull_ has joined #ingres | 14:24 | |
| withdefault | and for your next project you can use the queries here http://blogs.planetingres.org/notnull/2006/06/08/ima-guru-pronounced-im-a-guru-i-definitely-am-not/ ;) | 14:25 |
| elPiola | withdefault, if I'm ever allowed to let go of VMS, I'm supposed to claim responsibility for IMA (I had started but the VMS vortex pulled me back) | 14:35 |
| pboro | withdefault, thanks for the tip :) I'll bookmark that | 14:40 |
| withdefault | elPiola, that's a shame - I understand the concept of the code vortex, but they never seem to die instead they seem to grow in number | 14:40 |
| pboro | ah... DBD-Ingres: "dbdimp.sc", line 745: warning: implicit function declaration: Newx | 14:46 |
| pboro | any tips what Newx is? | 14:46 |
| elPiola | withdefault, the only hope is that since the associated hardware (at least Alpha and certainly VAX) is dying, the code vortex loses its strength as well | 14:46 |
| pboro | ah, Perl version difference :) | 14:50 |
| pboro | DBD-Ingres requires Perl 5.8.8 | 14:50 |
| pboro | it's not mentioned anywhere tho' | 14:51 |
| pboro | I'll drop an email about it :) | 14:51 |
| *** DarylM has joined #ingres | 14:52 | |
| elPiola | withdefault, how come the tags in your blog don't work? | 14:55 |
| withdefault | I don't know - I'll have to speak with the admin | 14:56 |
| elPiola | correction: the tags in the tag cloud work, it's just that IMA article's tags that aren't actually tags | 14:58 |
| withdefault | Ah, they may have been added prior to the blog software being updated | 15:04 |
| withdefault | yup - they're in the body of the post - I've manually added them now | 15:12 |
| pboro | ah, figured it out... | 15:28 |
| grantc | elPiola, getting what we have in IMA documented would be a start :) | 15:33 |
| pboro | grantc, http://www.nntp.perl.org/group/perl.dbi.users/2009/02/msg33698.html | 15:34 |
| pboro | grantc, the problem is that DBD-Ingres requires Perl 5.8.8 because of the use of Newx function | 15:34 |
| pboro | grantc, Newx was New (with slightly different parameters) before 5.8.8 | 15:34 |
| grantc | drop an email to the maintainer | 15:34 |
| pboro | I did file a bug, I couldn't find maintainers email anywhere | 15:35 |
| grantc | or perhaps it can be fixed with a ifdef? | 15:35 |
| pboro | prolly, don't know since I have no knowledge on programming Perl modules | 15:35 |
| grantc | there is a community driver email for ingres... | 15:36 |
| pboro | http://rt.cpan.org/Public/Bug/Display.html?id=43662 | 15:37 |
| grantc | community.drivers@ | 15:38 |
| troal01 | pboro: Stefan Reddig is the DBD-Ingres maintainer I believe: Stefan.Reddig@ingres.com | 15:42 |
| pboro | troal01, ok, thanks. I guess he'll get the message from the CPAN's bug tracker too, tho' | 15:43 |
| pboro | at least I hope so, since I don't see point in sending the same message through several routes :) | 15:43 |
| troal01 | Oh no, people love getting the same information several times, make sure you call him after you've e-mailed him! | 15:43 |
| pboro | I'll file a bug in service desk too | 15:44 |
| troal01 | Hehehe | 15:44 |
| grantc | pboro, testing driver code against multiple releases is a PITA | 15:51 |
| grantc | especially multiple ingres vs multiple lang | 15:51 |
| pboro | I can imagize :) | 15:52 |
| grantc | then producing DLLs for windows... the release process for the PHP driver lasts 1 day from the last commit... | 15:53 |
| pboro | :D | 15:54 |
| *** mull_ has quit IRC | 16:44 | |
| *** bonro011 has left #ingres | 16:57 | |
| *** bonro01 has joined #ingres | 16:57 | |
| *** DerMeister has joined #ingres | 17:08 | |
| grantc | SlimeyPete, the latest incantation of the docs for the php extension can be found at http://croker.net/~grant/ingres-doc/ | 19:03 |
| grantc | also CVS has version 2.1.0 which will be release tomorrow | 19:03 |
| grantc | released even | 19:03 |
| pboro | grantc, it's nice to see someone doing so much good work on the PHP driver :) | 19:04 |
| troal01 | grantc: Do you have release notes for php 2.1.0? | 19:08 |
| troal01 | pboro: that makes two of us :) | 19:08 |
| grantc | release notes are the same as 2.0.2 with the following applied s/2.0.2/2.1.0/g :) | 19:13 |
| grantc | if its the CHANGELOG you are looking for.... http://cvs.php.net/viewvc.cgi/pecl/ingres/CHANGELOG?revision=1.58&view=co | 19:13 |
| troal01 | Did you ever get a chance to investigate that issue I was having? | 19:19 |
| *** Alex|off is now known as Alex| | 20:56 | |
| *** Alex| is now known as Alex|off | 21:05 | |
| *** DerMeister has quit IRC | 21:23 | |
| *** rossand has quit IRC | 21:55 | |
| pboro | err... http://community.ingres.com/wiki/Ingres_2006_Release_4_Update_1 | 22:12 |
| pboro | why does that page look like that? | 22:12 |
| SlimeyPete | :o NOW WE KNOW THEY USE ARRAYS IN THEIR WEBSITE! | 22:15 |
| pboro | ... | 22:15 |
| pboro | the point was that there is prolly something else too :D | 22:15 |
| pboro | or at least I would expect... oh well | 22:15 |
| *** perftuning has joined #ingres | 22:25 | |
| *** DarylM has quit IRC | 22:50 | |
| *** mull_ has joined #ingres | 23:27 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!