*** PaulM05 has joined #ingres | 01:30 | |
*** PaulM05 has quit IRC | 01:31 | |
*** PaulM05 has joined #ingres | 01:58 | |
*** PaulM06 has joined #ingres | 02:01 | |
PaulM06 | testing 1 2 3 | 02:01 |
---|---|---|
*** PaulM06 has quit IRC | 02:01 | |
*** cthibert has joined #ingres | 03:09 | |
*** jenseben has joined #ingres | 04:10 | |
*** jenseben has quit IRC | 04:23 | |
*** grassi has joined #ingres | 04:25 | |
*** Dejan has joined #ingres | 04:29 | |
grassi | Hi everybody. I'd like to change the default value of a "field" in a relation from 0 to 1. I can't figure out the syntax, though... Does anyone know how that can be accomplished? | 04:29 |
grassi | "alter table customer alter column pricelist int " works, but I don't know how to set the default value... | 04:29 |
PaulM05 | alter table customer alter column pricelist int default 6 | 04:31 |
grassi | thanks. that's what i figured out right now too. but... | 04:32 |
grassi | it says, default values cannot be ammended to a previously ammended table... | 04:33 |
grassi | use "usermod <tablename> to return table to base form and retry. | 04:33 |
PaulM05 | did you try that? | 04:34 |
grassi | maybe because i tried this and that before... | 04:34 |
grassi | yeah, except i used 1 instead of 6 ;-) | 04:34 |
grassi | ah you mean the usermod | 04:34 |
grassi | no, acually i'm afraid of commands i don't know. | 04:34 |
grassi | can something go wrong with "usermod tablename"? | 04:35 |
grassi | i'll just try it right now.... | 04:35 |
PaulM05 | well if it's a large table it will take time and may require sufficient work space | 04:35 |
Dejan | hi guys | 04:36 |
grassi | ok. no problem | 04:36 |
PaulM05 | hi Dejan | 04:36 |
grassi | it's not that big. | 04:36 |
grassi | great! many thanks PaulM05 !! After the usermod, it seemed to work. :-) | 04:39 |
PaulM05 | no problem | 04:40 |
grassi | bye folks. | 04:42 |
*** grassi has quit IRC | 04:42 | |
*** PaulM05 has quit IRC | 04:49 | |
*** atrofast has quit IRC | 04:50 | |
*** PaulM05 has joined #ingres | 04:50 | |
*** atrofast has joined #ingres | 04:50 | |
*** PaulM05 has quit IRC | 04:50 | |
*** PaulM05 has joined #ingres | 04:52 | |
*** mull has quit IRC | 05:11 | |
*** rossand has quit IRC | 05:21 | |
*** rossand has joined #ingres | 05:44 | |
*** ChanServ sets mode: +o rossand | 05:44 | |
*** mull has joined #ingres | 05:52 | |
*** Dejan has quit IRC | 06:09 | |
*** Dejan has joined #ingres | 06:19 | |
*** DarylM has quit IRC | 07:01 | |
*** cthibert has left #ingres | 07:15 | |
*** cthibert has joined #ingres | 07:19 | |
*** Dejan has quit IRC | 08:18 | |
*** Mud has quit IRC | 08:46 | |
*** Mud has joined #ingres | 08:50 | |
*** grantc has joined #ingres | 08:57 | |
*** atrofast has quit IRC | 09:25 | |
*** rossand has quit IRC | 09:48 | |
*** grantc has quit IRC | 09:49 | |
*** PaulM05 has quit IRC | 09:50 | |
*** grantc has joined #ingres | 10:02 | |
*** DarylM has joined #ingres | 10:42 | |
*** Alex| has joined #ingres | 10:46 | |
*** ChanServ sets mode: +o Alex| | 10:46 | |
*** cytrinox_ has joined #ingres | 11:00 | |
*** cytrinox has quit IRC | 11:02 | |
*** cytrinox_ is now known as cytrinox | 11:02 | |
*** rossand has joined #ingres | 11:42 | |
*** ChanServ sets mode: +o rossand | 11:42 | |
*** Alex| has quit IRC | 11:46 | |
*** grantc has quit IRC | 11:50 | |
*** Mud has quit IRC | 12:19 | |
*** Mud has joined #ingres | 12:20 | |
*** atrofast has joined #ingres | 12:38 | |
*** Mud has quit IRC | 13:44 | |
*** cthibert has left #ingres | 13:53 | |
*** mull has quit IRC | 14:29 | |
*** rossand has quit IRC | 14:45 | |
*** atrofast has quit IRC | 15:01 | |
*** DarylM has quit IRC | 15:37 | |
*** rossand has joined #ingres | 16:10 | |
*** ChanServ sets mode: +o rossand | 16:10 | |
*** mull has joined #ingres | 18:50 | |
*** cytrinox_ has joined #ingres | 21:20 | |
*** cytrinox has quit IRC | 21:23 | |
*** cytrinox_ is now known as cytrinox | 21:23 | |
*** rossand has quit IRC | 21:40 | |
*** Alex| has joined #ingres | 22:09 | |
*** ChanServ sets mode: +o Alex| | 22:09 | |
*** Alex| has quit IRC | 22:39 | |
*** Mud has joined #ingres | 22:55 | |
*** Alex| has joined #ingres | 23:20 | |
*** ChanServ sets mode: +o Alex| | 23:20 | |
*** grantc has joined #ingres | 23:41 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!