| *** Alex| has joined #ingres | 00:18 | |
| *** ChanServ sets mode: +o Alex| | 00:18 | |
| *** Mud has quit IRC | 00:40 | |
| *** Mud has joined #ingres | 00:47 | |
| *** grantc has joined #ingres | 00:51 | |
| *** Mud has quit IRC | 01:11 | |
| *** Mud has joined #ingres | 01:16 | |
| *** Dejan has joined #ingres | 01:50 | |
| Dejan | hello everybody | 01:51 |
|---|---|---|
| Dejan | guys, check this out: http://codepad.org/GMbiah46 | 01:51 |
| Dejan | i get that error when i try to sysmod a database | 01:51 |
| Dejan | what could cause that, and how to fix it? any advice is greatly appreciated | 01:52 |
| Dejan | the database seems to work well | 01:52 |
| *** KermitTheFragger has joined #ingres | 02:07 | |
| Dejan | KermitTheFragger, hiya | 02:49 |
| KermitTheFragger | Dejan: hello! | 02:49 |
| Dejan | question: is there an SQL statement like SHOW GRANTS on MySQL/Maria ? | 02:50 |
| Dejan | i do not want to use visualdb or accessdb just for this purpose... | 02:50 |
| KermitTheFragger | Dejan: you can use show grants as SQL in MySQL iirc ? | 02:51 |
| KermitTheFragger | Dejan: here it is: http://dev.mysql.com/doc/refman/5.0/en/show-grants.html | 02:52 |
| KermitTheFragger | or am i missing something ? :) | 02:53 |
| Dejan | that is what i want in ingres | 03:00 |
| Dejan | i am aware of show grants in maria/mysql | 03:01 |
| Vroomfondle | select * from iiperms? | 03:01 |
| Dejan | sure... | 03:02 |
| grantc | HELP PERMIT ON x | 03:04 |
| grantc | where x is the object you wish to query | 03:04 |
| Dejan | hell, how did i miss that one... | 03:06 |
| Dejan | :/ | 03:06 |
| Dejan | thanks grantc | 03:06 |
| Dejan | iiperms seems inaccessible | 03:07 |
| Dejan | maybe i have to be superuser | 03:07 |
| KermitTheFragger | Dejan: ah sorry i missread, I need more coffee ;-) | 03:08 |
| Dejan | next question: how to grant NEXT for a sequence ? | 03:29 |
| Dejan | i am trying to find this in the documentation, and i am failing... | 03:30 |
| Dejan | GRANT NEXT ON SEQUENCE '$iiidentity_sequence_0011666' TO USER app_pma;\g | 03:34 |
| Dejan | what is wrong with this? | 03:34 |
| Dejan | this sequence exists | 03:34 |
| Dejan | user exists too | 03:34 |
| Dejan | i noticed this because my Java app throws an exception: SQLException: NEXT VALUE: you lack 'NEXT' on sequence '$iiidentity_sequence_0011666' owned by 'ingres'. | 03:34 |
| Dejan | hell, it was frekkin' quotes... | 03:47 |
| Dejan | when i used double quotes it worked... | 03:47 |
| Dejan | is there a way to name the sequence autogenerated for AUTO_INCREMENT field? | 03:50 |
| Dejan | or a way to easily grant NEXT to those sequences... | 03:50 |
| *** cthibert has joined #ingres | 03:56 | |
| * Dejan wishes AUTO_INCREMENT(seq_name) in CREATE TABLE :D | 04:10 | |
| Dejan | because i just hate autogenerated sequence names... | 04:11 |
| Alex| | you know about "always as identity" in 9.3? | 04:21 |
| Alex| | ah, you want the other way? You know about default seq_name.nextval? | 04:22 |
| Dejan | sure i do Alex| , question here is - can i specify the name of the sequence if i use AUTO_INCREMENT alias? | 04:39 |
| Dejan | what I want is: GENERATE ALWAYS AS my_sequence_name IDENTITY | 04:39 |
| Dejan | example: | 04:39 |
| Dejan | CREATE TABLE tt(id INTEGER PRIMARY KEY GENERATE ALWAYS AS my_sequence_name IDENTITY, ...) | 04:39 |
| Dejan | what I want is: | 04:40 |
| Dejan | CREATE TABLE tt(id INTEGER PRIMARY KEY AUTO_INCREMENT(my_sequence_name), ...) | 04:40 |
| Dejan | why? | 04:40 |
| Dejan | because I cannot know the sequence name that Ingres is going to make for the AUTO_INCREMENT | 04:40 |
| Dejan | sure, my option is to forget AUTO_INCREMENT, and stick to the longer syntax | 04:41 |
| Dejan | i need this sequence name, because i need it to set access to it | 04:41 |
| Dejan | (in GRANT NEXT ON SEQUENCE...) | 04:42 |
| Dejan | I consider it a bug actually - if i grant access to a table with identity column, the sequence should be automatically updated as well | 04:42 |
| Dejan | if it is, i would not have this problem at all | 04:43 |
| Dejan | so users would have access to all those $autosequences_NNNN | 04:43 |
| Dejan | and sure, i do not exclude posibility that i just do not know how to do it :D | 04:44 |
| *** gerhard has joined #ingres | 05:07 | |
| *** Mud has quit IRC | 05:11 | |
| *** Mud has joined #ingres | 05:16 | |
| *** zxiiro has quit IRC | 05:30 | |
| *** Dejan_ has joined #ingres | 05:34 | |
| *** gerhard has quit IRC | 05:36 | |
| *** rossand has joined #ingres | 05:55 | |
| *** ChanServ sets mode: +o rossand | 05:55 | |
| *** zxiiro has joined #ingres | 06:14 | |
| *** ChanServ sets mode: +v zxiiro | 06:14 | |
| *** gerhard has joined #ingres | 06:37 | |
| *** gerhard has quit IRC | 06:49 | |
| *** Alex| has quit IRC | 07:24 | |
| *** Mud has quit IRC | 08:00 | |
| *** Alex| has joined #ingres | 08:17 | |
| *** ChanServ sets mode: +o Alex| | 08:17 | |
| *** ukjay has joined #ingres | 08:19 | |
| *** Dejan has quit IRC | 09:08 | |
| *** Mud has joined #ingres | 09:12 | |
| *** Mud has quit IRC | 09:54 | |
| *** KermitTheFragger has quit IRC | 10:07 | |
| *** Alex| has quit IRC | 10:10 | |
| *** ukjay has left #ingres | 10:16 | |
| *** grantc has quit IRC | 11:43 | |
| *** zxiiro has quit IRC | 11:51 | |
| *** withdefault has quit IRC | 12:04 | |
| *** Alex| has joined #ingres | 12:18 | |
| *** ChanServ sets mode: +o Alex| | 12:18 | |
| *** cthibert has left #ingres | 12:54 | |
| *** zxiiro has joined #ingres | 13:09 | |
| *** ChanServ sets mode: +v zxiiro | 13:09 | |
| *** Alex| has quit IRC | 13:22 | |
| *** bonro01 has left #ingres | 13:35 | |
| *** cytrinox_ has joined #ingres | 19:21 | |
| *** cytrinox has quit IRC | 19:24 | |
| *** cytrinox_ is now known as cytrinox | 19:24 | |
| *** rossand has quit IRC | 19:29 | |
| *** Alex| has joined #ingres | 22:36 | |
| *** ChanServ sets mode: +o Alex| | 22:36 | |
| *** Mud has joined #ingres | 22:53 | |
| *** DarylM has quit IRC | 23:12 | |
| *** Alex| has quit IRC | 23:13 | |
| *** Mud has quit IRC | 23:18 | |
| *** Mud has joined #ingres | 23:29 | |
| *** grantc has joined #ingres | 23:44 | |
| *** zxiiro has quit IRC | 23:53 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!