| *** dyki has quit IRC | 01:00 | |
| *** Alex| has quit IRC | 02:59 | |
| *** Alex| has joined #ingres | 03:48 | |
| *** ChanServ sets mode: +o Alex| | 03:48 | |
| *** Alex| has quit IRC | 03:49 | |
| *** Alex| has joined #ingres | 03:49 | |
| *** ChanServ sets mode: +o Alex| | 03:49 | |
| *** Alex| has quit IRC | 04:16 | |
| *** rossand has joined #ingres | 04:22 | |
| *** ChanServ sets mode: +o rossand | 04:22 | |
| *** ultrav1olet has joined #ingres | 04:52 | |
| ultrav1olet | I have installed Ingres 10 on Linux. What's the easiest way to import MySQL DB? | 04:52 |
|---|---|---|
| *** ultrav1olet has quit IRC | 05:09 | |
| *** ultrav1olet has joined #ingres | 05:10 | |
| ultrav1olet | I have installed Ingres 10 on Linux. What's the easiest way to import MySQL DB? | 05:10 |
| bonsaikitten | ultrav1olet: that'll be fun | 05:49 |
| bonsaikitten | you can motivate mysql to create a plaintext dump, which you could then massage until it can be imported by ingres | 05:50 |
| bonsaikitten | but there will be lots of pain in the process because what mysql thinks is "SQL" and what everyone else uses is slightly different | 05:50 |
| atrofast | Yeah MySQL is notorious for not following standards :P | 05:55 |
| atrofast | PostgreSQL <-> Ingres is easier | 05:55 |
| bonsaikitten | why would you do that? ;) | 05:57 |
| atrofast | Just saying it can be done easier, not that it should be done ;) | 05:57 |
| bonsaikitten | :) | 05:57 |
| atrofast | If Ingres was off the table, I'd take Postgres over MySQL any day | 05:58 |
| bonsaikitten | well, you want a DB, right? | 05:58 |
| bonsaikitten | so mysql doesn't qualify ;) | 05:58 |
| atrofast | Haha | 05:59 |
| bonsaikitten | MyISAM is a nice game, and InnoDB ... wuargh. Not funny. | 05:59 |
| *** mull has joined #ingres | 06:42 | |
| *** Alex| has joined #ingres | 06:49 | |
| *** ChanServ sets mode: +o Alex| | 06:49 | |
| *** Alex| has quit IRC | 07:19 | |
| *** Dejan has joined #ingres | 07:37 | |
| Dejan | hi everybody | 07:37 |
| *** Dejan has quit IRC | 07:55 | |
| *** Dejan has joined #ingres | 08:28 | |
| * Dejan is back | 08:28 | |
| Dejan | question: what is the easiest way to rename a PK field in a table? | 09:09 |
| Dejan | drop table, make a new one and then copy? | 09:09 |
| grantc | at the moment that is the only option | 09:19 |
| grantc | alter table rename column is in the pipe line | 09:19 |
| Vroomfondle | woohoo, looks like we might *finally* move to 9.2 next week | 09:19 |
| grantc | http://community.ingres.com/wiki/Tables_Columns_Rename | 09:20 |
| grantc | Vroomfondle: just as 9.2.1 comes out? :) | 09:20 |
| Vroomfondle | unfortunately it took a catastrophic failure in our 2.6 system to precipitate this | 09:20 |
| Vroomfondle | but, meh, all's well that ends well I guess | 09:20 |
| Vroomfondle | grantc: heh, naturally | 09:20 |
| *** DerMeister has joined #ingres | 09:32 | |
| Dejan | it is actually more tricksy... | 09:33 |
| Dejan | because the colum is an identity column... | 09:33 |
| Dejan | khm... | 09:33 |
| *** Alex| has joined #ingres | 09:37 | |
| *** ChanServ sets mode: +o Alex| | 09:37 | |
| *** pboro has quit IRC | 09:57 | |
| Dejan | i cannot wait RENAME TABLE|COLUMN to be in Ingres... | 09:59 |
| *** pboro has joined #ingres | 10:04 | |
| *** zxiiro has joined #ingres | 10:06 | |
| *** ChanServ sets mode: +v zxiiro | 10:06 | |
| *** pboro has quit IRC | 10:06 | |
| *** pboro has joined #ingres | 10:13 | |
| *** Alex| has quit IRC | 11:53 | |
| *** zxiiro_ has joined #ingres | 12:47 | |
| *** zxiiro has quit IRC | 12:47 | |
| *** rossand has quit IRC | 13:40 | |
| *** DerMeister has quit IRC | 14:29 | |
| *** grantc has quit IRC | 14:38 | |
| *** mull has quit IRC | 15:01 | |
| *** bonsaikitten has quit IRC | 15:29 | |
| *** bonsaikitten has joined #ingres | 15:36 | |
| *** bonsaikitten has quit IRC | 15:48 | |
| *** bonsaikitten has joined #ingres | 15:54 | |
| *** rossand has joined #ingres | 15:57 | |
| *** ChanServ sets mode: +o rossand | 15:57 | |
| *** rossand has quit IRC | 16:00 | |
| *** rossand has joined #ingres | 17:16 | |
| *** ChanServ sets mode: +o rossand | 17:16 | |
| *** zxiiro_ has quit IRC | 18:04 | |
| *** mull has joined #ingres | 18:08 | |
| *** mull has quit IRC | 18:34 | |
| *** cytrinox_ has joined #ingres | 19:20 | |
| *** cytrinox has quit IRC | 19:37 | |
| *** cytrinox_ is now known as cytrinox | 19:37 | |
| *** rossand has quit IRC | 20:08 | |
| *** rossand has joined #ingres | 20:15 | |
| *** ChanServ sets mode: +o rossand | 20:15 | |
| *** rossand has quit IRC | 20:30 | |
| *** rossand has joined #ingres | 20:36 | |
| *** ChanServ sets mode: +o rossand | 20:36 | |
| *** rossand has quit IRC | 20:38 | |
| ultrav1olet | How can I import SQL file from the shell? | 21:32 |
| *** grantc has joined #ingres | 21:38 | |
| *** ChanServ sets mode: +o grantc | 21:38 | |
| *** Alex| has joined #ingres | 22:37 | |
| *** ChanServ sets mode: +o Alex| | 22:37 | |
| *** Alex| has quit IRC | 23:03 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!