*** grantc has joined #ingres | 00:34 | |
*** ChanServ sets mode: +o grantc | 00:34 | |
Alex| | morning - there is no way to alter a column to not null without recreating the table, is it? | 00:54 |
---|---|---|
pboro | not that I know of... one of the excuses were "the dbms can't know what to do with existing nulls" :( | 00:55 |
Alex| | not a good one I have to say | 00:55 |
pboro | I proposed that filling the default value would be fine or prevent alter table if there's nulls | 00:55 |
pboro | so one could replace nulls with proper values before doing alter table | 00:56 |
Alex| | that's what one would expect, yeah | 00:56 |
Vroomfondle | Hmm. Has anyone here managed to insert/update into Ingres via a LinkedServer from MSSQL? | 01:36 |
atrofast | Does Ingres have SQL functions that take more than 4 arguments? | 04:55 |
*** atrofast has quit IRC | 04:58 | |
*** atrofast has joined #ingres | 05:06 | |
*** mull has joined #ingres | 05:25 | |
*** Deyan has joined #ingres | 06:04 | |
Deyan | hello | 06:04 |
atrofast | Hey Deyan | 06:29 |
atrofast | Hey Grant, when I compile ingres-php 2.2.1 against SVN main head rev I get this error when it tries to load the module: Unable to load dynamic library 'modules/ingres.so' - /opt/Ingres/IngresSV/ingres/lib/libq.1.so: undefined symbol: clock_gettime in Unknown on line 0 | 06:34 |
atrofast | Oops sorry, grantc, have you seen that before? | 06:35 |
Deyan | do you have that library there? | 06:38 |
Deyan | wait... /opt/Ingres/IngresSV/ingres/lib/libq.1.so is lib you have built from Ingres SVN trunk ? | 06:40 |
*** DarylM has joined #ingres | 06:42 | |
atrofast | Yeah I built from svn trunk | 06:43 |
atrofast | I'm working on some stuff and wanted to test a PHP project but it seems it doesn't like to be built against SVN trunk somehow | 06:43 |
Deyan | could be that clock_gettime is removed | 06:44 |
Deyan | khm.... | 06:45 |
Deyan | clock_gettime is a function somewhere else | 06:45 |
*** rossand has joined #ingres | 06:46 | |
*** ChanServ sets mode: +o rossand | 06:46 | |
Deyan | nah, that is a typical function... | 06:48 |
Deyan | from declared in time.h | 06:49 |
atrofast | If I do an nm libq.1.so and it has clock_gettime defined | 06:49 |
Deyan | ? | 06:50 |
Deyan | it has "U clock_gettime" | 06:50 |
Deyan | which means it just uses that symbol from some other library | 06:50 |
*** rossand has quit IRC | 06:51 | |
atrofast | Ahh I see | 06:51 |
*** rossand has joined #ingres | 06:51 | |
*** ChanServ sets mode: +o rossand | 06:51 | |
Deyan | i suppose it is in libc | 06:52 |
*** rossand1 has joined #ingres | 06:53 | |
atrofast | an nm on libc.so.6 shows no clock_gettime | 06:53 |
*** Deyan has quit IRC | 07:06 | |
*** rossand has quit IRC | 07:11 | |
*** Dejan has joined #ingres | 07:13 | |
grantc | its in librt | 07:14 |
Dejan | grantc: did you have a chance to take a look at that issue i submitted on PECL bugzilla? | 07:15 |
grantc | hi Dejan not as yet sorry. I do know that PHP does not release all the memory back but what you are seeing is excessive | 07:15 |
Dejan | okay, fair enough | 07:17 |
Dejan | luckily, i have 32GB RAM on this test server... | 07:18 |
*** rossand1 has quit IRC | 07:19 | |
atrofast | grantc: Any idea why the ingres php driver doesn't pick that lib up? | 07:25 |
atrofast | Or is the problem in the Ingres server? | 07:25 |
grantc | it's not the driver it's that someone has screwed up | 07:25 |
grantc | putting it politely | 07:25 |
Dejan | it works here | 07:25 |
Dejan | however, i do not have svn version of ingres... | 07:26 |
grantc | clock_gettime was added in 9.2 and this problem came up them. I raised an issue, it got fixed. So it would seem to be a regression - log an issue in SD | 07:27 |
grantc | the issue i originally opened is 127052 | 07:28 |
grantc | http://lists.ingres.com/pipermail/ip-os-drivers/2008-July/000084.html for example was the change i added for the Python driver | 07:29 |
atrofast | AH okay, what if I just link ingres.so to librt? | 07:30 |
grantc | add "PHP_ADD_LIBRARY_WITH_PATH(rt, $II_LIB_DIR, INGRES_SHARED_LIBADD)" to the config.m4 with the other entries | 07:31 |
grantc | then run phpize .... | 07:31 |
atrofast | Okay thanks! | 07:31 |
grantc | or perhaps PHP_ADD_LIBRARY(rt, INGRES_SHARED_LIBADD) | 07:35 |
grantc | looking through the svn logs it would appear that i never had to add it. I guess it was fixed before I needed to submit it | 07:35 |
atrofast | Your first suggestion worked | 07:38 |
atrofast | I don't get the error anymore | 07:38 |
atrofast | Now Ingres itself just segfaults :D | 07:39 |
atrofast | Most likely nothing to do with your driver | 07:39 |
*** Alex| is now known as Alex|off | 07:46 | |
*** rossand has joined #ingres | 08:32 | |
*** ChanServ sets mode: +o rossand | 08:32 | |
*** rossand1 has joined #ingres | 08:48 | |
*** zxiiro has quit IRC | 08:49 | |
*** rossand2 has joined #ingres | 08:58 | |
*** rossand has quit IRC | 09:01 | |
*** rossand2 has quit IRC | 09:03 | |
*** rossand1 has quit IRC | 09:15 | |
*** Dejan has quit IRC | 09:59 | |
*** zxiiro has joined #ingres | 11:18 | |
*** ChanServ sets mode: +v zxiiro | 11:18 | |
*** grantc has quit IRC | 12:05 | |
*** rossand has joined #ingres | 12:18 | |
*** ChanServ sets mode: +o rossand | 12:18 | |
*** rossand1 has joined #ingres | 12:26 | |
*** mull_ has joined #ingres | 12:35 | |
*** mull has quit IRC | 12:35 | |
*** rossand has quit IRC | 12:42 | |
*** mull_ has quit IRC | 12:57 | |
*** mull_ has joined #ingres | 12:59 | |
*** DerMeister has joined #ingres | 13:01 | |
*** rossand has joined #ingres | 13:11 | |
*** ChanServ sets mode: +o rossand | 13:11 | |
*** rossand2 has joined #ingres | 13:13 | |
*** rossand3 has joined #ingres | 13:17 | |
*** rossand has quit IRC | 13:19 | |
*** rossand2 has quit IRC | 13:23 | |
*** rossand1 has quit IRC | 13:28 | |
*** rossand has joined #ingres | 13:42 | |
*** ChanServ sets mode: +o rossand | 13:42 | |
*** rossand3 has quit IRC | 13:48 | |
*** rossand1 has joined #ingres | 14:06 | |
*** rossand has quit IRC | 14:23 | |
*** rossand has joined #ingres | 14:36 | |
*** ChanServ sets mode: +o rossand | 14:36 | |
*** mull_ has quit IRC | 14:42 | |
*** rossand1 has quit IRC | 14:53 | |
*** DarylM has quit IRC | 15:15 | |
*** DerMeister has quit IRC | 15:23 | |
*** rossand has quit IRC | 15:31 | |
*** rossand has joined #ingres | 17:03 | |
*** ChanServ sets mode: +o rossand | 17:03 | |
*** rossand has quit IRC | 18:06 | |
*** rossand has joined #ingres | 20:52 | |
*** ChanServ sets mode: +o rossand | 20:52 | |
*** rossand has quit IRC | 21:50 | |
*** Alex|off is now known as Alex| | 23:52 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!