| *** grantc has joined #ingres | 00:24 | |
| *** ChanServ sets mode: +o grantc | 00:24 | |
| *** grantc has quit IRC | 00:30 | |
| *** Alex| has joined #ingres | 00:56 | |
| *** ChanServ sets mode: +o Alex| | 00:56 | |
| *** Nornagest has joined #ingres | 00:57 | |
| *** atrofast has left #ingres | 02:55 | |
| *** grantc has joined #ingres | 03:09 | |
| *** ChanServ sets mode: +o grantc | 03:09 | |
| grantc | morning all, does anyone know how to get the current date/time using a timestamp column? for ingresdate we have date('now') but i cannot find the equivalent for timestamp | 03:16 |
|---|---|---|
| Alex| | isn't there a constant defined? | 03:17 |
| Alex| | CURRENT_TIMESTAMP | 03:18 |
| grantc | ta | 03:20 |
| Alex| | as it is a constant you can even use it in create table statements | 03:21 |
| grantc | that's what i want it for | 03:21 |
| Alex| | :) | 03:21 |
| grantc | arg .. i was one page before that one ... should have scrolled on.. | 03:21 |
| grantc | damn doc site | 03:21 |
| grantc | Alex|, when you did the mw port for ingres did you have to setup the database manually? | 03:32 |
| Alex| | yes | 03:32 |
| Alex| | we never migrated the install script | 03:32 |
| grantc | ok | 03:32 |
| Alex| | it's more or less a dump of a mysql installation | 03:32 |
| grantc | that much i guessed - i took the tables.sql file from svn and ported it based on the DB2 schema | 03:33 |
| Alex| | I'm not sure if the mw installer does anything other than simply running the sql script | 03:33 |
| grantc | it does some checks i believe ... | 03:56 |
| Alex| | what's the default lock level in current Ingres releases - table level? | 04:46 |
| *** atrofast has joined #ingres | 05:05 | |
| *** rossand has joined #ingres | 05:39 | |
| *** ChanServ sets mode: +o rossand | 05:39 | |
| grantc | Alex|, the default is page, escalating to table when some condition occurs | 05:48 |
| grantc | there is an escalation level, if i remember correctly it's 10 pages... | 05:48 |
| Alex| | ok, I guess he gets into the usual readlock issue in his web app... | 05:49 |
| grantc | readlock=nolock should not cause escalations | 05:49 |
| Alex| | yup.. he just sees deadlocks and I told him to use readlock=nolock | 05:50 |
| grantc | perhaps he should use read committed and perhaps row level locking (depending on the number of rows in a page) | 05:50 |
| *** mull has joined #ingres | 06:00 | |
| *** DarylM has joined #ingres | 06:50 | |
| *** skythe has joined #ingres | 07:56 | |
| *** rossand1 has joined #ingres | 07:56 | |
| *** rossand has quit IRC | 07:57 | |
| *** zxiiro has quit IRC | 08:09 | |
| *** DerMeister has joined #ingres | 10:09 | |
| *** rossand1 has quit IRC | 10:40 | |
| *** rossand has joined #ingres | 11:16 | |
| *** ChanServ sets mode: +o rossand | 11:16 | |
| *** NoeWork has joined #ingres | 11:19 | |
| thiagomz | guys... how you get statistics from your databases ? | 12:01 |
| thiagomz | i´m using -zk -zc | 12:01 |
| thiagomz | Alex|: how can i setup readlock=nolock to all my system... and clientes... i have a client server environment. | 12:02 |
| thiagomz | Alex|: my want my system work as "read commited" | 12:03 |
| DarylM | thiagomz: the configuration parameter is system_isolation and readlock=nolock is not the same as read committed | 12:19 |
| thiagomz | DarylM: humm | 12:20 |
| DarylM | In fact, mixing the old Ingres based readlock= setting and the ANSI isolation levels can be extremely confusing. | 12:21 |
| DarylM | and even depend on the >>order<< you issue the statements. | 12:21 |
| thiagomz | ingres is pessimist ou otimistic | 12:22 |
| thiagomz | or | 12:22 |
| DarylM | pessimistic locking | 12:22 |
| DarylM | Most systems build optimistic locking at the app level (or middleware level) | 12:22 |
| DarylM | You usually only want to use the dbms locking system for its ACID ability | 12:23 |
| DarylM | In fact you could probably write an entire book on the subject | 12:24 |
| * DarylM things that is a cool idea...... | 12:24 | |
| * DarylM thinks** (rarely) | 12:24 | |
| *** atrofast has quit IRC | 12:31 | |
| thiagomz | :) | 12:43 |
| thiagomz | bye guys | 12:58 |
| thiagomz | my day finished | 12:58 |
| *** thiagomz has quit IRC | 12:58 | |
| *** NoeWork has quit IRC | 13:16 | |
| *** NoeWork has joined #ingres | 13:16 | |
| *** rossand has quit IRC | 13:19 | |
| *** NoeWork has quit IRC | 13:43 | |
| *** NoeWork has joined #ingres | 13:43 | |
| *** grantc has quit IRC | 14:13 | |
| *** DerMeister has quit IRC | 14:21 | |
| *** NoeWork has quit IRC | 16:01 | |
| *** mull has quit IRC | 16:59 | |
| *** DarylM has quit IRC | 18:14 | |
| *** skythe has quit IRC | 19:04 | |
| *** zxiiro has joined #ingres | 19:04 | |
| *** pboro has quit IRC | 20:36 | |
| *** Nornagest has quit IRC | 20:36 | |
| *** Nornagest has joined #ingres | 20:36 | |
| *** pboro has joined #ingres | 20:36 | |
| *** zxiiro has quit IRC | 21:19 | |
| *** zxiiro has joined #ingres | 21:19 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!