*** Mud|game is now known as Mud | 00:27 | |
Vroomfondle | yes | 00:59 |
---|---|---|
Vroomfondle | copy table my_table(my_number c0nl) from 'my_file.txt' | 01:00 |
Vroomfondle | though that 'c0nl' might have to be altered to match the actual data type | 01:00 |
pboro | ah, yeah | 01:01 |
pboro | damn I hate the documentation, COPY INTO/FROM is so badly documented | 01:01 |
pboro | thanks | 01:01 |
*** grantc has joined #ingres | 01:10 | |
*** ChanServ sets mode: +o grantc | 01:10 | |
*** Mud is now known as Mud|afk | 01:30 | |
*** PaulM05 has joined #ingres | 02:36 | |
*** cthibert has joined #ingres | 03:43 | |
*** PaulM05 is now known as PaulM_at_lunch | 04:37 | |
*** Dejan has joined #ingres | 05:08 | |
*** Gerhard has joined #ingres | 05:08 | |
Dejan | hello everybody | 05:08 |
*** Dejan is now known as Guest73765 | 05:08 | |
Gerhard | Hi Dejan | 05:09 |
Guest73765 | hi Gerhard | 05:20 |
*** Guest73765 is now known as Dejan | 05:20 | |
*** PaulM_at_lunch is now known as PaulM05 | 05:23 | |
*** cthibert has left #ingres | 05:52 | |
*** zxiiro has joined #ingres | 05:55 | |
*** ChanServ sets mode: +v zxiiro | 05:55 | |
*** cthibert has joined #ingres | 05:55 | |
*** atrofast has joined #ingres | 06:00 | |
*** rossand has joined #ingres | 06:11 | |
*** ChanServ sets mode: +o rossand | 06:11 | |
*** atrofast has quit IRC | 06:12 | |
*** atrofast has joined #ingres | 06:15 | |
*** Alex| has quit IRC | 06:16 | |
*** ccsidiot has joined #ingres | 07:15 | |
Dejan | 3 | 07:17 |
atrofast | 4 | 07:20 |
grantc | buffer overflow... | 07:24 |
atrofast | Hehe | 07:25 |
*** anonymous_ has joined #ingres | 07:28 | |
*** mull has joined #ingres | 08:04 | |
*** Alex| has joined #ingres | 08:25 | |
*** ChanServ sets mode: +o Alex| | 08:25 | |
Vroomfondle | grantc: if I have a result-set identifier created using ingres_prepare(), is there any way to discover the SQL string which was passed to ingres_prepare()? | 08:48 |
Vroomfondle | (I imagine not, but just thought I'd ask) | 08:48 |
grantc | not right now | 08:48 |
grantc | is there any reason you would want to know what the query was? beyond diags? | 08:49 |
Vroomfondle | just diagnostics. I'm making my wrapper function raise an exception with various bits of info incl. the SQL included in it | 08:50 |
Vroomfondle | it's no big deal - generally we don't use prepared statements anyway | 08:50 |
Vroomfondle | but I'm making my function flexible enough to allow us to do so in the future. | 08:50 |
grantc | if you are wrapping up the function in your own class you could store the query in a private variable | 08:51 |
Vroomfondle | it's not currently in a class, though I've been toying with the idea. | 08:51 |
Vroomfondle | I might try and hack something like that together tomorrow, see how it flies | 08:51 |
*** Gerhard has left #ingres | 08:55 | |
*** rilson has joined #ingres | 08:55 | |
*** rilson has left #ingres | 08:56 | |
*** josky has joined #ingres | 08:57 | |
josky | hi folks, is there a OLD DB driver for Ingres? | 08:58 |
josky | OLE DB* | 08:58 |
grantc | josky, nope, you will have to use OLE DB via ODBC | 08:59 |
josky | grantc, ok, thx | 08:59 |
grantc | no problem - is this for .NET ? | 08:59 |
josky | grantc, for Java, is there a provider for .NET? | 09:01 |
grantc | Ingres has a .NET provider and a JDBC driver | 09:01 |
grantc | and a bunch of other drivers, but not OLE DB :) | 09:01 |
grantc | http://esd.ingres.com/product/drivers/JDBC | 09:02 |
josky | grantc, great, would you have some link to those non-OLE DB drivers? | 09:02 |
grantc | for the JDBC driver you need to connect to an installation of Ingres that has a DAS server (process is called iigcd) running | 09:03 |
grantc | http://esd.ingres.com/product/drivers - if you are looking for spring/hibernate stuff that stuff is located elsewhere | 09:03 |
grantc | also if you are using mavern you can pull the ingres drivers from there | 09:04 |
grantc | http://community.ingres.com/wiki/Ingres_JDBC_With_Maven | 09:04 |
josky | grantc, cool, I'll take a look | 09:05 |
*** ccsidiot has quit IRC | 09:20 | |
*** Alex| has quit IRC | 09:43 | |
*** josky has quit IRC | 10:09 | |
*** Dejan has quit IRC | 10:29 | |
*** PaulM05 has quit IRC | 10:40 | |
*** Mud|afk is now known as Mud | 10:44 | |
*** vuja has joined #ingres | 11:06 | |
*** Alex| has joined #ingres | 11:08 | |
*** ChanServ sets mode: +o Alex| | 11:08 | |
*** zxiiro has quit IRC | 11:41 | |
*** zxiiro has joined #ingres | 11:43 | |
*** ChanServ sets mode: +v zxiiro | 11:43 | |
*** Mud is now known as Mud|afk | 11:45 | |
*** zxiiro has quit IRC | 12:11 | |
*** zxiiro has joined #ingres | 12:12 | |
*** ChanServ sets mode: +v zxiiro | 12:12 | |
*** vuja has quit IRC | 12:12 | |
*** cthibert has left #ingres | 12:42 | |
*** atrofast has quit IRC | 12:53 | |
*** atrofast has joined #ingres | 12:55 | |
*** ccsidiot has joined #ingres | 13:13 | |
*** Alex| has quit IRC | 13:27 | |
*** mull has quit IRC | 13:50 | |
*** zxiiro has quit IRC | 13:53 | |
ccsidiot | Hey everyone, is there any documentation about the source tree of Geospatial somewhere? | 14:22 |
ccsidiot | I can see for each c file, there is a very nice comment block describing history, but I want to know what is some particular file about, is there something like that? | 14:23 |
atrofast | ccsidiot: This helped me a great deal: http://community.ingres.com/wiki/A_Short_Excursion_Through_The_Ingres_Back-End | 14:30 |
ccsidiot | Thanks :) | 14:34 |
*** zxiiro has joined #ingres | 14:40 | |
*** ChanServ sets mode: +v zxiiro | 14:40 | |
*** grantc has quit IRC | 14:58 | |
*** Mud|afk has quit IRC | 16:21 | |
*** rossand has quit IRC | 17:19 | |
*** DarylM has quit IRC | 19:18 | |
*** zxiiro has quit IRC | 19:18 | |
*** ccsidiot has quit IRC | 19:18 | |
*** atrofast has quit IRC | 19:18 | |
*** cytrinox has quit IRC | 19:18 | |
*** bonro01 has quit IRC | 19:18 | |
*** FrankW has quit IRC | 19:18 | |
*** clach04 has quit IRC | 19:18 | |
*** Vroomfondle has quit IRC | 19:18 | |
*** zxiiro has joined #ingres | 19:18 | |
*** ccsidiot has joined #ingres | 19:18 | |
*** atrofast has joined #ingres | 19:18 | |
*** cytrinox has joined #ingres | 19:18 | |
*** FrankW has joined #ingres | 19:18 | |
*** bonro01 has joined #ingres | 19:18 | |
*** clach04 has joined #ingres | 19:18 | |
*** Vroomfondle has joined #ingres | 19:18 | |
*** irc.freenode.net sets mode: +v zxiiro | 19:18 | |
*** cytrinox_ has joined #ingres | 19:26 | |
*** cytrinox has quit IRC | 19:37 | |
*** cytrinox_ is now known as cytrinox | 19:37 | |
*** Gerhard has joined #ingres | 21:25 | |
*** ccsidiot has left #ingres | 21:30 | |
*** grantc has joined #ingres | 22:09 | |
*** ChanServ sets mode: +o grantc | 22:09 | |
*** DarylM has joined #ingres | 22:27 | |
*** Alex| has joined #ingres | 22:27 | |
*** Adross has joined #ingres | 22:31 | |
Adross | i've been trying to install ingres on ubuntu karmic, but gcc-3.4 has been removed. Should i add the package manually, or is there a more elegant method? | 22:32 |
*** ChanServ sets mode: +o Alex| | 22:44 | |
Gerhard | Adross, I'm not very familiar with Ubuntu. The package management is APT based on Unbuntu, right? | 22:53 |
Adross | Gerhard, yes. My question was irrelevant however, the new versions of ingres will compile with the newer versions of gcc | 23:00 |
Adross | i think the problems I'm having stem from bldenv | 23:00 |
Adross | trying a few things, I'll keep you posted | 23:00 |
Gerhard | Ah, you install from source? | 23:02 |
grantc | Adross, ingres builds ok for me on karmic | 23:03 |
*** Gerhard has quit IRC | 23:03 | |
*** Alex| has quit IRC | 23:03 | |
Adross | grantc, were there any special packages you needed to install? | 23:09 |
grantc | not that i remember | 23:10 |
grantc | although I would need to test out on a clean system to be sure | 23:10 |
Adross | I had to change line 151 of src/tools/port/jam/bldenv to xvers=28 | 23:11 |
Adross | and even now, it hangs at ingres/install/vt220.map | 23:13 |
grantc | you can override the version using an env var | 23:16 |
grantc | XERCVERS=28 | 23:18 |
*** Alex| has joined #ingres | 23:19 | |
*** ChanServ sets mode: +o Alex| | 23:19 | |
Adross | i see | 23:19 |
grantc | someone else had the hanging map file the other day - perhaps it was one of your ucsop people | 23:20 |
*** ii_log` is now known as ii_log | 23:21 | |
*** bonro011 has joined #ingres | 23:21 | |
*** bonro01 has quit IRC | 23:22 | |
*** Adross has quit IRC | 23:36 | |
*** Gerhard has joined #ingres | 23:41 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!