*** 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!