*** rossand has quit IRC | 00:26 | |
*** DarylM has quit IRC | 00:50 | |
*** thoda05 has left #ingres | 02:31 | |
*** NoeJeko has quit IRC | 03:52 | |
*** NoeJeko has joined #ingres | 03:52 | |
*** grantc_offline is now known as grantc | 08:42 | |
*** rossand has joined #ingres | 13:39 | |
*** ChanServ sets mode: +o rossand | 13:39 | |
*** grantc is now known as grantc_offline | 13:55 | |
*** rossand has quit IRC | 21:32 | |
*** yoeljacobsen has joined #ingres | 22:30 | |
yoeljacobsen | Hello | 22:30 |
---|---|---|
yoeljacobsen | I'm toying with an example from one of Celko's books but get a problem with Ingres: | 22:31 |
yoeljacobsen | * drop table outline; | 22:31 |
yoeljacobsen | * CREATE TABLE Outline | 22:31 |
yoeljacobsen | * (section_nbr VARCHAR(15) NOT NULL PRIMARY KEY, | 22:31 |
yoeljacobsen | * CHECK (section_nbr SIMILAR TO '([:digit:][:digit:]\.)+')); | 22:31 |
yoeljacobsen | * \g | 22:31 |
yoeljacobsen | Executing . . . | 22:31 |
yoeljacobsen | continue | 22:31 |
yoeljacobsen | * insert into outline values ('11.');\g | 22:31 |
yoeljacobsen | Executing . . . | 22:31 |
yoeljacobsen | E_US1905 Check integrity constraint '"$outli_c000001ba00000000"' | 22:31 |
yoeljacobsen | on table '"outline"' was violated. | 22:31 |
yoeljacobsen | (Sat May 16 14:29:36 2009) | 22:31 |
yoeljacobsen | Why is the constraint valioted? | 22:31 |
yoeljacobsen | violated.. | 22:31 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!