| *** Alex| has joined #ingres | 00:15 | |
| *** ChanServ sets mode: +o Alex| | 00:15 | |
| *** KermitTheFragger has joined #ingres | 00:54 | |
| *** withdefault has joined #ingres | 00:56 | |
| *** ChanServ sets mode: +o withdefault | 00:56 | |
| *** gerhard has joined #ingres | 01:06 | |
| gerhard | Hi all | 01:06 |
|---|---|---|
| *** Mud has quit IRC | 01:07 | |
| *** Mud has joined #ingres | 01:13 | |
| *** Dejan has joined #ingres | 01:15 | |
| Dejan | good morning everybody | 01:15 |
| *** PaulM05 has joined #ingres | 01:19 | |
| gerhard | Morning Dejan | 01:19 |
| Dejan | morning PaulM05 | 01:19 |
| PaulM05 | morning Dejan | 01:20 |
| Alex| | http://www.flickr.com/photos/prozac74/4530623061/ | 01:38 |
| PaulM05 | :) | 01:44 |
| Dejan | "If you fire x% of your staff to realize y% productivity gains, then firing all your staff should give you infinite productivity assuming geometrically progressive rising gains..." | 01:44 |
| Dejan | this comment was the best | 01:45 |
| Alex| | don't tell that your management :) | 01:52 |
| Dejan | Do not worry, i will not give them idea | 01:59 |
| * grantc_away is back (gone 02:45:25) | 02:04 | |
| Dejan | wb grant | 02:05 |
| grantc_away | hi Dejan | 02:05 |
| *** grantc_away is now known as grantc | 02:05 | |
| PaulM05 | morningr grantc | 02:05 |
| grantc | morning PaulM05 | 02:05 |
| *** atrofast has joined #ingres | 04:25 | |
| *** PaulM05 is now known as PaulM05_lunch | 04:32 | |
| *** cthibert has joined #ingres | 04:33 | |
| *** gerhard has quit IRC | 04:35 | |
| *** maida01 has joined #ingres | 04:58 | |
| *** Mud has quit IRC | 05:08 | |
| *** Mud has joined #ingres | 05:13 | |
| *** atrofast has quit IRC | 05:13 | |
| *** zxiiro has quit IRC | 05:31 | |
| *** PaulM05_lunch is now known as PaulM05 | 05:35 | |
| *** atrofast has joined #ingres | 05:37 | |
| *** grantc has quit IRC | 06:02 | |
| *** mull has joined #ingres | 06:17 | |
| *** grantc has joined #ingres | 06:24 | |
| *** zxiiro has joined #ingres | 06:24 | |
| *** ChanServ sets mode: +v zxiiro | 06:24 | |
| *** grantc has quit IRC | 06:29 | |
| *** grantc has joined #ingres | 06:43 | |
| *** withdefault has quit IRC | 06:56 | |
| *** withdefault has joined #ingres | 07:10 | |
| *** ChanServ sets mode: +o withdefault | 07:10 | |
| *** toumi01 has joined #ingres | 07:10 | |
| *** withdefault sets mode: -o withdefault | 07:11 | |
| *** Alex| has quit IRC | 08:17 | |
| Dejan | guys, do i have to re-create table if i want to change to NODUPLICATES ? | 08:36 |
| PaulM05 | no just re-modify | 08:37 |
| PaulM05 | assuming that you're removed duplicates of course ;) | 08:37 |
| Dejan | what i get is: E_PS0BC6 MODIFY: Line 1, duplicates is not a valid option for WITH clause. | 08:38 |
| Dejan | modify tablename to reconstruct with duplicates;\g | 08:39 |
| Dejan | that is what i tried | 08:39 |
| Dejan | also modify tablename to hash on column with duplicates;\g | 08:39 |
| Dejan | same error | 08:39 |
| *** atrofast has quit IRC | 08:49 | |
| *** atrofast has joined #ingres | 08:52 | |
| PaulM05 | looks like you do need to re-create the table | 08:57 |
| Dejan | yep | 09:03 |
| Dejan | that is why i asked if i have to re-create it | 09:03 |
| PaulM05 | well I thought you could do it with a modify but I was wrong | 09:04 |
| *** Mud has quit IRC | 09:07 | |
| Dejan | i need to change couple of hundreds of tables... | 09:10 |
| Dejan | from DUPLICATES to NODUPLICATES... | 09:10 |
| *** Mud has joined #ingres | 09:13 | |
| PaulM05 | [NO]DUPLICATES applies across the whole row - it might be easier to make the table structure unique on whatever key | 09:14 |
| Dejan | what you mean by "applies across the whole row" ? | 09:16 |
| PaulM05 | I mean that creating a table with NODUPLICATES means the entire row must be unique. | 09:18 |
| PaulM05 | as opposed to say BTREE UNIQUE on col1,col2 etc | 09:18 |
| PaulM05 | but a unique key implies you can't have a duplicate row | 09:19 |
| Dejan | aha, the point is - they made many tables without any keys... | 09:19 |
| Dejan | but some of those tables must be NODUPLICATE | 09:20 |
| Dejan | because we should not allow duplicate rows in them | 09:20 |
| Dejan | and they do not have duplicates | 09:20 |
| Dejan | it is a legacy databases I want to ... "fix" | 09:20 |
| Dejan | simply by doing simple modifications | 09:21 |
| PaulM05 | well you'll need a key to enforce the uniqueness - a heap table always allows duplicates | 09:21 |
| Dejan | yeah, i read about that | 09:21 |
| PaulM05 | anyway - I'm away home - bye | 09:41 |
| *** PaulM05 has quit IRC | 09:41 | |
| *** grantc has quit IRC | 09:42 | |
| *** Alex| has joined #ingres | 10:02 | |
| *** ChanServ sets mode: +o Alex| | 10:02 | |
| *** Dejan has quit IRC | 10:03 | |
| *** KermitTheFragger has quit IRC | 10:10 | |
| *** atrofast has quit IRC | 10:11 | |
| *** atrofast has joined #ingres | 11:17 | |
| withdefault | part time to go home | 12:05 |
| *** withdefault has left #ingres | 12:05 | |
| *** DerMeister has joined #ingres | 12:06 | |
| *** cthibert has left #ingres | 12:25 | |
| *** DerMeister has quit IRC | 12:45 | |
| *** Mud has quit IRC | 13:07 | |
| *** maida01 has quit IRC | 13:12 | |
| *** Mud has joined #ingres | 13:13 | |
| *** Alex| has quit IRC | 13:53 | |
| *** zxiiro has quit IRC | 14:05 | |
| *** Mud has quit IRC | 14:48 | |
| *** zxiiro has joined #ingres | 14:51 | |
| *** ChanServ sets mode: +v zxiiro | 14:51 | |
| *** mull has quit IRC | 15:46 | |
| *** atrofast has quit IRC | 18:05 | |
| *** rossand has quit IRC | 18:47 | |
| *** twice2double has joined #ingres | 18:53 | |
| *** twice2double has quit IRC | 18:55 | |
| *** epoitras has joined #ingres | 19:01 | |
| *** epoitras has left #ingres | 19:06 | |
| *** epoitras has joined #ingres | 19:12 | |
| *** cytrinox has quit IRC | 19:24 | |
| *** cytrinox has joined #ingres | 19:26 | |
| *** clach04 has quit IRC | 22:19 | |
| *** pboro has quit IRC | 22:22 | |
| *** Alex| has joined #ingres | 22:36 | |
| *** ChanServ sets mode: +o Alex| | 22:36 | |
| *** Alex| has quit IRC | 22:58 | |
| *** Alex| has joined #ingres | 23:15 | |
| *** ChanServ sets mode: +o Alex| | 23:15 | |
| *** j0nnY has joined #ingres | 23:35 | |
| *** j0nnY has left #ingres | 23:37 | |
| *** withdefault has joined #ingres | 23:49 | |
| *** ChanServ sets mode: +o withdefault | 23:49 | |
| *** withdefault sets mode: -o withdefault | 23:50 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!