*** atrofast has quit IRC | 00:01 | |
*** atrofast has joined #ingres | 01:04 | |
Deyan | hello | 01:42 |
---|---|---|
*** grantc has joined #ingres | 01:47 | |
*** ChanServ sets mode: +o grantc | 01:47 | |
*** grantc has quit IRC | 02:16 | |
*** grantc has joined #ingres | 02:22 | |
*** ChanServ sets mode: +o grantc | 02:22 | |
Deyan | strange thing is - if i declare a column as AUTO_INCREMENT, ingres does not allow me to insert a value into it by simple INSERT INTO <table name>(id) values(<number>) | 02:43 |
Deyan | even though i am giving a valid, new value | 02:43 |
pboro | what is the error when trying to insert? | 02:43 |
Deyan | a weird error... hold on | 02:43 |
Deyan | it is probably my mistake | 02:43 |
Deyan | i am still thinking in MySQL-ways :D | 02:44 |
grantc | Hi Deyan, I am not sure that inserting values in to a server managed column is a really good idea (tm) | 02:44 |
pboro | it depends | 02:44 |
pboro | in Ingres you prolly use sequence for auto incrementing column | 02:45 |
grantc | on? | 02:45 |
Deyan | grantc, i agree, but unfortunately the software i am using requires me to give it a value | 02:45 |
pboro | grantc, on the case :D maybe you want to reuse some ids or something... I have no idea what Deyan is building :) | 02:45 |
Deyan | PS, it is a testing table... | 02:45 |
grantc | pboro, hmm | 02:46 |
Deyan | "INSERT: Overriding system value clause must accompany INSERT into GENERATED ALWAYS AS IDENTITY column id." | 02:46 |
Deyan | it is a table with 2 rows in it | 02:47 |
Deyan | so i know 100% that value i want to add is definitely correct | 02:47 |
Deyan | sure when i execute my own sql code everything goes well | 02:48 |
pboro | ahh... is there other ways to create "auto-incrementing" column in ingres other than sequences? :) | 02:48 |
grantc | pboro - yes but they are hacky | 02:48 |
Deyan | but for the testing i use squirrel-sql just to fill tables with some crappy data | 02:48 |
Deyan | and it REQUIRES me to supply value for the auto_increment column... | 02:48 |
Deyan | stupid if you ask me, but that is how it works... | 02:49 |
grantc | RTFM :) http://docs.ingres.com/Ingres/9.3/SQL%20Reference%20Guide/insert.htm | 02:50 |
grantc | OVERRIDING SYSTEM VALUE | 02:50 |
Deyan | yessir | 02:51 |
Deyan | ay ay sir | 02:51 |
* Deyan lives to obey! | 02:51 | |
grantc | ;) | 02:51 |
Deyan | ah this... | 02:52 |
Deyan | this will not help, grantc | 02:52 |
grantc | like anything when you shout it works... like talking to foreigners ... | 02:52 |
Deyan | because i cannot make squirrel use OVERRIDING SYSTEM VALUE | 02:52 |
grantc | :( | 02:53 |
pboro | Ah, I didn't know Ingres protects columns which use sequences for default value | 02:53 |
grantc | can you not override the SQL? or have it generate the SQL and you modify it | 02:53 |
grantc | pboro, i think this is new for 9.3 | 02:54 |
grantc | it comes with GENERATED ALWAYS AS IDENTITY/GENERATED BY DEFAULT IDENTITY | 02:54 |
pboro | grantc, ok, is that ANSI SQL compatible or an Ingres extension? | 02:54 |
grantc | i don't think it would apply with 9.2 using old method of sequence number inclusion... | 02:55 |
grantc | pls hold caller... | 02:55 |
Deyan | if you ask me, this is good | 02:55 |
Deyan | (that ingres protects IDENTITY columns) | 02:55 |
Deyan | but the problem is to make software be more intelligent | 02:55 |
pboro | it seems to be by the standard :) nice | 02:55 |
grantc | pboro, i would guess it is an ISO SQL standard | 02:55 |
Deyan | (like squirrel, or razorsql) | 02:55 |
grantc | db2 use the same | 02:56 |
pboro | grantc, and Derby and many others, yup | 02:56 |
Deyan | pboro: it is a standard | 02:56 |
Deyan | i could not find db editor that actually could detect this column and use proper sql when i want to add some data to such table... | 02:57 |
Vroomfondle | hmm | 03:06 |
Vroomfondle | where does Ingres store its forms (ABF/vision)? I think it's in a system database somewhere but I don't know how to gain access to it. | 03:07 |
Deyan | from my short experience with Ingres, you cannot access system database through ODBC | 03:10 |
Deyan | maybe that is the problem? | 03:10 |
Deyan | or somewhat related to it? | 03:11 |
grantc | Vroomfondle, perhaps in ii_encoded_forms | 03:11 |
grantc | Deyan, you mean iidbdb? | 03:11 |
Deyan | grantc: for some reason i cannot access any table with prefix sys_ | 03:12 |
grantc | that's not an ingres prefix | 03:12 |
grantc | our system tables start with ii | 03:12 |
grantc | ii for dbms tables ii_ for application (abf/replicator/vision/openroad/reportwriter) | 03:12 |
Vroomfondle | we don't seem to have an ii_encoded_forms, or else our DBA account can't see it | 03:15 |
grantc | select relid from iirelation where relid like 'ii_%' order by relid asc | 03:18 |
grantc | that might be for OpenROAD... | 03:18 |
Vroomfondle | ah, my bad - was looking in the wrong place | 03:18 |
Vroomfondle | we do have an ii_encoded_forms and an ii_forms. Not sure I'll be able to do what I wanted to do though. | 03:19 |
Vroomfondle | (I wanted to effective 'grep' through all our forms for a given field/column name or trim text) | 03:19 |
Vroomfondle | looks like that might be a non-starter | 03:19 |
grantc | dump the forms using copyform and review the output | 03:20 |
Vroomfondle | that might be a better approach, yeah | 03:23 |
*** atrofast has quit IRC | 03:51 | |
*** atrofast has joined #ingres | 03:54 | |
atrofast | That IDENTITY feature, is that in main code line already? | 03:55 |
Alex| | it's in 9.3... | 03:55 |
Alex| | so I guess, yes... | 03:55 |
*** thiagomz has joined #ingres | 03:56 | |
atrofast | Cool, that feature will be nice when porting apps | 03:56 |
Deyan | not just that... it removes the need for generating proper values in the application logic... | 03:58 |
atrofast | Hey I didn't design the apps, I just port them :D | 03:59 |
Alex| | well, you can already create auto-sequences... you just have to take care about creating them which identiy will do for you then | 03:59 |
atrofast | It removes one step from the whole deal, also you don't have tow orry about naming the sequence | 03:59 |
grantc | atrofast, amen... | 04:04 |
*** atrofast has quit IRC | 04:17 | |
thiagomz | morning... | 04:18 |
Deyan | morning | 04:20 |
*** atrofast has joined #ingres | 04:38 | |
*** Deyan has quit IRC | 05:01 | |
*** atrofast has quit IRC | 05:11 | |
*** atrofast has joined #ingres | 05:11 | |
*** Deyan has joined #ingres | 06:38 | |
Deyan | hello | 06:38 |
pboro | hi :) | 06:39 |
*** DarylM has joined #ingres | 06:57 | |
*** toumi01 has joined #ingres | 06:59 | |
*** mull has joined #ingres | 07:01 | |
thiagomz | Guys, who can help to interpret a sampling on a DBMS ---> http://ingres.pastebin.com/mf1b0642 | 07:19 |
*** mull has joined #ingres | 07:23 | |
*** thiagomz has quit IRC | 07:27 | |
*** thiagomz_ has joined #ingres | 07:27 | |
*** thiagomz_ has quit IRC | 07:28 | |
*** thiagomz has joined #ingres | 07:29 | |
*** Alex| is now known as Alex|off | 07:30 | |
*** mull has quit IRC | 07:32 | |
*** thiagomz_ has joined #ingres | 07:35 | |
*** dyki has joined #ingres | 07:35 | |
*** thiagomz has quit IRC | 07:35 | |
Deyan | dyki: yo bro | 07:35 |
Deyan | wassup? | 07:35 |
dyki | Deyan: jo! | 07:36 |
dyki | good :) | 07:36 |
Deyan | <-- AFK | 07:36 |
DarylM | thiagomz: looks pretty normal. not much to interpret. moving a lot of data into/out-of the server | 07:38 |
*** thiagomz_ has quit IRC | 07:39 | |
*** thiagomz has joined #ingres | 07:39 | |
thiagomz | Wazzaaappp - > http://www.youtube.com/watch?v=G0Ez90yZvFM | 07:40 |
thiagomz | funny ! | 07:40 |
thiagomz | http://www.youtube.com/watch?v=6F2PA5sVjek | 07:42 |
*** DerMeister has joined #ingres | 08:55 | |
*** Alex|off is now known as Alex| | 09:43 | |
Deyan | dyki: :) | 09:51 |
dyki | Deyan: ingres rules! | 09:51 |
Deyan | sure mate | 09:51 |
Deyan | totally pwns | 09:51 |
dyki | what is happening to these t-shirts? | 09:51 |
Deyan | shipped | 09:52 |
Deyan | i will make all my chicks wear them in my bedroom | 09:52 |
dyki | whoa! | 09:52 |
Deyan | just those t-shirts, nothing else | 09:52 |
dyki | I think they might be a bit overbuilt! | 09:52 |
*** grantc has quit IRC | 10:01 | |
*** Deyan has quit IRC | 10:04 | |
*** Alex| is now known as Alex|off | 13:40 | |
*** DerMeister has quit IRC | 14:12 | |
dyki | q | 14:40 |
*** dyki has quit IRC | 14:40 | |
*** DarylM has quit IRC | 15:45 | |
*** atrofast has quit IRC | 16:00 | |
*** Nornagest has quit IRC | 19:19 | |
*** Alex|off has quit IRC | 22:45 | |
*** Alex| has joined #ingres | 22:45 | |
*** Nornagest has joined #ingres | 22:46 | |
*** Alex| is now known as Alex|off | 22:47 | |
*** Alex|off is now known as Alex| | 22:47 | |
*** ChanServ sets mode: +o Alex| | 22:47 | |
*** withdefault has joined #ingres | 22:57 | |
*** ChanServ sets mode: +o withdefault | 22:57 | |
*** Alex| is now known as Alex|off | 23:06 | |
*** Alex|off is now known as Alex| | 23:21 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!