*** Alex| has joined #ingres | 00:02 | |
*** ChanServ sets mode: +o Alex| | 00:02 | |
*** Dejan has joined #ingres | 00:45 | |
*** Dejan_ has joined #ingres | 00:45 | |
Dejan | ups | 00:46 |
---|---|---|
Dejan | :D | 00:46 |
Dejan | good morning gents | 00:46 |
*** grantc has joined #ingres | 00:59 | |
*** KermitTheFragger has joined #ingres | 00:59 | |
Dejan | morning guys | 01:00 |
grantc | morning Dejan | 01:01 |
*** Mud has quit IRC | 01:03 | |
*** Mud has joined #ingres | 01:10 | |
*** PaulM05 has joined #ingres | 01:14 | |
Dejan | hello PaulM05 & Mud | 01:26 |
PaulM05 | moring Dejan | 01:27 |
Dejan | guys, i was thinking yesterday about something that IMHO may be very useful | 01:46 |
Dejan | i think it would be just great if Ingres offers a way to use D-BUS to connect to a database | 01:47 |
Dejan | or, even better, to all installations | 01:47 |
Dejan | D-BUS is already a "standard" on Linux | 01:48 |
pboro | what would you use if for? | 01:48 |
Dejan | to get data | 01:49 |
Dejan | D-BUS is now used for all kind of IPC | 01:51 |
Dejan | on Linux | 01:51 |
*** withdefault has quit IRC | 02:16 | |
*** withdefault has joined #ingres | 02:27 | |
*** ChanServ sets mode: +o withdefault | 02:27 | |
*** withdefault sets mode: -o withdefault | 02:27 | |
*** stliu has quit IRC | 03:30 | |
*** Alex| has quit IRC | 03:31 | |
*** stliu has joined #ingres | 03:40 | |
* Dejan thinks MODIFY statement should have "WITH JOURNALING" option as well | 03:53 | |
Dejan | :) | 03:53 |
PaulM05 | do you mean to enable journaling? | 03:53 |
Dejan | yeah | 03:54 |
Dejan | it would an alternative to SET JOURNALING ON ... | 03:54 |
Dejan | a first thought of a noob like me was to use MODIFY TABLE <table name> TO RECONSTRUCT WITH JOURNALING | 03:55 |
Dejan | (to enable journaling) | 03:56 |
Dejan | sure SET JOURNALING ON is a better option than reconstruct... | 03:56 |
Dejan | :) | 03:57 |
Dejan | but IMHO journaling should be in the MODIFY statement too | 03:57 |
Dejan | somehow | 03:57 |
Dejan | :) | 03:57 |
PaulM05 | perhaps | 03:57 |
PaulM05 | MODIFY already does so much | 03:57 |
PaulM05 | which I suppose is why people think it does everything :) | 03:58 |
*** stliu has quit IRC | 04:01 | |
Dejan | yep :) | 04:01 |
Dejan | well, it makes sense - MODIFY is used for all kinds of table-modifications | 04:01 |
Dejan | and journaling is yet another one | 04:01 |
PaulM05 | it would have implications for your transactions | 04:03 |
PaulM05 | you'd only be able to do it at the start of a transaction | 04:03 |
Dejan | sure it does | 04:04 |
Dejan | those who know would use SET JOURNALING ON <table name> | 04:04 |
Dejan | those who do not know can still enable journaling | 04:04 |
Dejan | via MODIFY | 04:04 |
Dejan | :D | 04:04 |
PaulM05 | Which means you'd also start journaling before the modify if the modify made other changes | 04:05 |
Dejan | sure, no question about it | 04:05 |
PaulM05 | none of which is insurmountable | 04:05 |
Dejan | my point is more to help novices | 04:05 |
Dejan | to do something, even though it is not the best way to do it | 04:05 |
*** cthibert has joined #ingres | 04:12 | |
*** withdefault has quit IRC | 04:20 | |
*** siman01 has joined #ingres | 04:23 | |
*** rossand has joined #ingres | 04:32 | |
*** ChanServ sets mode: +o rossand | 04:32 | |
siman01 | hi guys is there a standard way to get the list of libraries required to link esql/c? I can see it might be defined in utility/iisysdep, I'm looking for something a bit like pkg-config that I can use in a make script | 04:36 |
grantc | siman01, unfortunately not | 04:38 |
grantc | -L$II_SYSTEM/ingres/lib -lq.1 -lframe.1 -lcompat.1 | 04:38 |
Dejan | pkg-config support in ingres is a good thing to have | 04:40 |
siman01 | thanks grant, I think I also need -lrt (for get_time) or am I doing something wrong (using 10.0.0 build 120) | 04:47 |
grantc | it's a bug - there were a large number of "improvements" made to the build process which caused some regressions, this was one of them. The fix was submitted into main in the last 24 hours. Until a new build is posted with the change included you have to manually link against librt.so | 04:49 |
siman01 | brilliant thanks | 04:50 |
grantc | https://bugs.ingres.com/changeset/2784 | 04:51 |
siman01 | Dejan I don't know enough about ingbuild to know if pkg-config configuration could be added but support would be useful | 04:52 |
Dejan | i absolutely agree | 04:59 |
Dejan | ingres uses jam atm i think | 04:59 |
Dejan | so it should be easy to generate .pc file | 04:59 |
grantc | in theory it should be simple - all the information is there in iisysdep... | 04:59 |
grantc | then you have the issue of the flags for openapi, odbc, or embedded SQL | 05:00 |
PaulM05 | if you have the source and a working build environment with the tests then you'll have seplnk | 05:03 |
*** atrofast has joined #ingres | 05:04 | |
*** Mud has quit IRC | 05:05 | |
PaulM05 | you could dig into the code for that to see how it determines the libraries (based on iisysdep no doubt) | 05:05 |
*** PaulM05 is now known as PaulM05_lunch | 05:05 | |
*** Mud has joined #ingres | 05:10 | |
*** siman01 has quit IRC | 05:22 | |
*** mull has joined #ingres | 05:53 | |
*** PaulM05_lunch is now known as PaulM05 | 05:59 | |
*** zxiiro has quit IRC | 06:00 | |
Dejan | Question: Where to get information about Ingres "uptime"? :) | 06:04 |
Dejan | ok, i can query errlog | 06:04 |
Dejan | and search through it.. | 06:05 |
Dejan | i wonder if imadb has that info :D | 06:05 |
*** atrofast has quit IRC | 06:12 | |
*** atrofast has joined #ingres | 06:26 | |
PaulM05 | @Dejan - here's a way to do it - http://ingres.pastebin.com/u86LXt5R | 06:37 |
ii_log | PaulM05: Error: "Dejan" is not a valid command. | 06:37 |
Dejan | @help | 06:38 |
ii_log | Dejan: (help [<plugin>] [<command>]) -- This command gives a useful description of what <command> does. <plugin> is only necessary if the command is in more than one plugin. | 06:38 |
Dejan | @select * from ii_log | 06:38 |
ii_log | Dejan: Error: "select" is not a valid command. | 06:38 |
Dejan | blah | 06:39 |
*** zxiiro has joined #ingres | 06:41 | |
*** ChanServ sets mode: +v zxiiro | 06:41 | |
*** Alex| has joined #ingres | 07:08 | |
*** ChanServ sets mode: +o Alex| | 07:08 | |
Vroomfondle | bah | 07:16 |
Dejan | i wonder why are we not allowed to change nullable column into a not-nullable, if we specify default value? | 07:26 |
*** bonro011 has joined #ingres | 07:31 | |
*** bonro01 has quit IRC | 07:33 | |
*** bonro01 has joined #ingres | 07:38 | |
*** bonro011 has quit IRC | 07:41 | |
*** bonro011 has joined #ingres | 07:50 | |
*** bonro011 has quit IRC | 07:51 | |
*** bonro011 has joined #ingres | 07:51 | |
*** bonro01 has quit IRC | 07:52 | |
*** bonro011 has quit IRC | 07:52 | |
*** bonro01 has joined #ingres | 07:52 | |
*** DerMeister has joined #ingres | 07:54 | |
*** KermitTheFragger has quit IRC | 08:08 | |
*** Alex| has quit IRC | 08:24 | |
*** Mud has quit IRC | 09:05 | |
*** ukjay has joined #ingres | 09:10 | |
pboro | Dejan, that's what I've been wondering often too | 09:18 |
Dejan | erm, guys | 09:38 |
Dejan | select mod(4, 0.3) takes ages... | 09:38 |
Dejan | :) | 09:38 |
Dejan | hell ukjay | 09:40 |
ukjay | dejan: morning | 09:41 |
Dejan | s/hell/hello/ | 09:41 |
Dejan | IMHO Ingres should shout when someone does MOD(4, 0.25) | 09:47 |
*** Dejan has quit IRC | 09:51 | |
ukjay | Anyone had trouble building head revs today? I'm getting: | 09:59 |
ukjay | /devsrc/main/b100/src/common/adf/adg/adgfi_defn.c:3337: error: ‘ADFI_1463_SINGLETON_ALL’ undeclared here (not in a function) | 09:59 |
ukjay | ... and similar. Think it's related to Alison's long IDs change | 09:59 |
pboro | at least my automated build system succeeded last night: http://www.fixel.org/ingres/20100413/jam_04_13_10_0322.log | 10:05 |
pboro | but it's based on trunk | 10:05 |
pboro | (i.e. it uses svn checkout http://code.ingres.com/ingres/main) | 10:05 |
pboro | that was for ukjay :) | 10:06 |
*** Mud has joined #ingres | 10:12 | |
*** Alex| has joined #ingres | 10:23 | |
*** ChanServ sets mode: +o Alex| | 10:23 | |
*** PaulM05 has quit IRC | 10:23 | |
ukjay | pboro: thanks. Will try svn, it should be the same as piccolo (internal). Might help me work out what's wrong. | 10:29 |
*** pboro has quit IRC | 10:42 | |
*** pboro has joined #ingres | 10:50 | |
*** DerMeister has quit IRC | 11:07 | |
*** DerMeister has joined #ingres | 11:26 | |
*** grantc has quit IRC | 11:31 | |
*** cthibert has left #ingres | 12:23 | |
*** cthibert has joined #ingres | 12:25 | |
*** zxiiro has quit IRC | 12:57 | |
*** Mud has quit IRC | 13:04 | |
*** Mud has joined #ingres | 13:10 | |
*** DerMeister has quit IRC | 13:21 | |
*** Alex| has quit IRC | 13:27 | |
*** Mud has quit IRC | 13:41 | |
*** zxiiro has joined #ingres | 13:44 | |
*** ChanServ sets mode: +v zxiiro | 13:44 | |
*** cthibert has left #ingres | 14:07 | |
*** atrofast has quit IRC | 16:58 | |
*** rossand has quit IRC | 17:23 | |
*** cytrinox_ has joined #ingres | 19:20 | |
*** cytrinox has quit IRC | 19:21 | |
*** cytrinox_ is now known as cytrinox | 19:21 | |
*** Alex| has joined #ingres | 22:35 | |
*** ChanServ sets mode: +o Alex| | 22:35 | |
*** grantc has joined #ingres | 22:35 | |
*** Alex| has quit IRC | 23:24 | |
*** withdefault has joined #ingres | 23:26 | |
*** ChanServ sets mode: +o withdefault | 23:26 | |
*** withdefault sets mode: -o withdefault | 23:27 | |
*** KermitTheFragger has joined #ingres | 23:36 | |
*** Alex| has joined #ingres | 23:42 | |
*** ChanServ sets mode: +o Alex| | 23:42 | |
*** ukjay has quit IRC | 23:52 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!