*** PaulM05 has joined #ingres | 00:57 | |
*** Dejan has joined #ingres | 01:14 | |
Dejan | hello | 01:14 |
---|---|---|
Dejan | hiya Paul | 01:14 |
PaulM05 | hi Dejan | 01:15 |
Dejan | how's everybody today? :) | 01:15 |
Vroomfondle | ello | 01:15 |
*** KermitTheFragger has joined #ingres | 01:18 | |
*** grantc has joined #ingres | 01:34 | |
*** Dejan has quit IRC | 01:49 | |
*** zxiiro has quit IRC | 02:02 | |
*** zxiiro has joined #ingres | 02:02 | |
*** ChanServ sets mode: +v zxiiro | 02:02 | |
*** zxiiro has quit IRC | 02:31 | |
*** zxiiro has joined #ingres | 02:33 | |
*** ChanServ sets mode: +v zxiiro | 02:34 | |
*** zxiiro has quit IRC | 02:38 | |
*** zxiiro has joined #ingres | 02:39 | |
*** ChanServ sets mode: +v zxiiro | 02:39 | |
*** zxiiro has quit IRC | 02:55 | |
*** zxiiro has joined #ingres | 02:56 | |
*** ChanServ sets mode: +v zxiiro | 02:56 | |
*** cthibert has joined #ingres | 03:30 | |
*** zxiiro has quit IRC | 03:33 | |
*** zxiiro has joined #ingres | 03:34 | |
*** ChanServ sets mode: +v zxiiro | 03:34 | |
*** Alex| has quit IRC | 03:35 | |
*** zxiiro has quit IRC | 03:38 | |
*** zxiiro has joined #ingres | 03:43 | |
*** ChanServ sets mode: +v zxiiro | 03:43 | |
*** rossand has joined #ingres | 03:44 | |
*** ChanServ sets mode: +o rossand | 03:44 | |
*** zxiiro has quit IRC | 03:51 | |
*** rossand has quit IRC | 03:55 | |
*** zxiiro has joined #ingres | 04:00 | |
*** ChanServ sets mode: +v zxiiro | 04:00 | |
*** zxiiro has quit IRC | 04:05 | |
*** zxiiro has joined #ingres | 04:06 | |
*** ChanServ sets mode: +v zxiiro | 04:06 | |
*** zxiiro has quit IRC | 04:18 | |
*** PaulM05 is now known as PaulM05_lunch | 05:01 | |
*** Alex| has joined #ingres | 05:10 | |
*** ChanServ sets mode: +o Alex| | 05:10 | |
*** DarylM has joined #ingres | 05:45 | |
*** Alex| has quit IRC | 06:00 | |
*** PaulM05_lunch is now known as PaulM05 | 06:01 | |
*** atrofast has joined #ingres | 06:04 | |
*** zxiiro has joined #ingres | 06:14 | |
*** ChanServ sets mode: +v zxiiro | 06:14 | |
Vroomfondle | Hmm... no Ingres for Mac OS X Intel. That's vaguely understandable, but sub-optimal ;) | 06:38 |
Vroomfondle | anyone got any creative solutions for hooking up a local web app on OSX to an Ingres database without paying money to anyone? | 06:38 |
PaulM05 | there's a community edition | 06:40 |
Vroomfondle | indeed, but no Intel port for Mac OS. | 06:41 |
Vroomfondle | there's a compilation guide for PowerPC but it implies right at the start that the code isn't expected to compile & run on Intel. | 06:41 |
PaulM05 | no there is | 06:41 |
PaulM05 | it's on ESD | 06:41 |
PaulM05 | under community downloads | 06:42 |
Vroomfondle | ah, I see. I was looking at 10.0 | 06:42 |
Vroomfondle | there's a port of 9.3. That'll do fine. | 06:42 |
Vroomfondle | thanks for making me look again ;) | 06:42 |
PaulM05 | there should be 10.0 at some point | 06:42 |
Vroomfondle | we're running 9.2 on our servers so 9.3 will be fine | 06:43 |
PaulM05 | :) | 06:43 |
*** gerhard has joined #ingres | 06:51 | |
*** mull has joined #ingres | 06:54 | |
Vroomfondle | bah, installed but won't run. Two steps forward... | 07:00 |
Vroomfondle | ah, shared memory fun eh | 07:02 |
Vroomfondle | hmm... I put in the recommended shared memory values from http://community.ingres.com/wiki/Building_ingres_on_mac . No dice. Recovery server fails to start. | 07:06 |
PaulM05 | could be a question for the forums - unfortunately I don't have an Intel Mac to play with | 07:07 |
Vroomfondle | I shall play around with it a bit more when I have time. Maybe increasing the settings further will work. | 07:11 |
*** cthibert has left #ingres | 07:12 | |
*** cthibert has joined #ingres | 07:15 | |
grantc | Vroomfondle, what Mac do you have? | 07:43 |
Vroomfondle | Macbook Pro. Fairly recent one. | 07:48 |
Vroomfondle | but not the very latest | 07:48 |
grantc | so 64-bit then | 07:55 |
grantc | there's a change under review that should help with 64-bit Mac | 07:56 |
grantc | assuming all goes well the change will be in SVN in the next day or so | 07:56 |
Vroomfondle | I see | 08:15 |
*** gerhard has quit IRC | 08:15 | |
Vroomfondle | thanks, grantc | 08:15 |
grantc | i cannot test the change as i only have a 32 bit mac | 08:16 |
*** Mud has joined #ingres | 08:42 | |
*** andylaw has joined #ingres | 08:43 | |
andylaw | I'm embarrassed to ask this, but... | 08:48 |
andylaw | I have some data that I have been asked to rescue from an openingres instance. I cannot for the life of me work out how to query the database structures | 08:49 |
andylaw | I can access the account as user 'ingres' and connect to the database using the command line 'sql' application. I can list tables using 'help' but I cannot see the table structure or query the tables | 08:49 |
andylaw | help <tablename> says that no tables matched | 08:50 |
PaulM05 | does ingres own the tables? | 08:50 |
andylaw | select * from <tablename> says the table does not exist or is not owned by you (right enough, it is owned by a different account) | 08:51 |
PaulM05 | easiest way would be to connect with "sql -u{username that owns tables} database" | 08:51 |
andylaw | @PaulM05 - That's one of the help items - --- | 08:51 |
ii_log | andylaw: Error: "PaulM05" is not a valid command. | 08:51 |
andylaw | Is the syntac of the -u flag without spaces (and, presumably, without braces}? | 08:52 |
andylaw | syntax | 08:52 |
PaulM05 | yes | 08:52 |
PaulM05 | e.g. sql -upaulm pauldb | 08:52 |
andylaw | I know my way in postgres and mysql - its been about 9 years since I touched an ingres system | 08:53 |
andylaw | If I connect as ingres, I can see the table owner | 08:53 |
andylaw | If I try to connect as the table owner, it tells me "The -u flag specified a nonexistent user" | 08:54 |
andylaw | This looks bad to me | 08:54 |
PaulM05 | you could create the user | 08:54 |
andylaw | Seems bizarre that the system "knows" the user (owner) even though it doesn't exist... | 08:55 |
PaulM05 | or connect as ingres and do "set session authorization 'user'" (where user is the username) - I think that works even if the user hasn't been created yet | 08:55 |
andylaw | Paul - you are my hero. | 08:56 |
PaulM05 | np | 08:56 |
andylaw | I very much appreciate it. Thanks. | 08:57 |
PaulM05 | you're welcome | 08:57 |
andylaw | And now I can see the table structures and the data, I'm starting to wish that I couldn't :( | 09:02 |
andylaw | Thanks again. Hopefully I'll manage from here. | 09:03 |
*** andylaw has quit IRC | 09:03 | |
*** PaulM05 has quit IRC | 09:40 | |
*** KermitTheFragger has quit IRC | 09:50 | |
*** grantc has quit IRC | 11:03 | |
*** Mud has quit IRC | 11:26 | |
*** Mud has joined #ingres | 11:31 | |
*** Mud has quit IRC | 13:35 | |
*** cthibert has left #ingres | 13:57 | |
*** zxiiro has quit IRC | 14:19 | |
*** zxiiro has joined #ingres | 15:10 | |
*** ChanServ sets mode: +v zxiiro | 15:10 | |
*** zxiiro has quit IRC | 15:15 | |
*** mull has quit IRC | 15:59 | |
*** mull has joined #ingres | 16:43 | |
*** atrofast has quit IRC | 17:58 | |
*** zxiiro has joined #ingres | 18:39 | |
*** ChanServ sets mode: +v zxiiro | 18:39 | |
*** cytrinox has quit IRC | 19:24 | |
*** cytrinox has joined #ingres | 19:26 | |
*** mull has quit IRC | 20:48 | |
*** gerhard has joined #ingres | 22:47 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!