Saturday, 2009-05-16

*** rossand has quit IRC00:26
*** DarylM has quit IRC00:50
*** thoda05 has left #ingres02:31
*** NoeJeko has quit IRC03:52
*** NoeJeko has joined #ingres03:52
*** grantc_offline is now known as grantc08:42
*** rossand has joined #ingres13:39
*** ChanServ sets mode: +o rossand13:39
*** grantc is now known as grantc_offline13:55
*** rossand has quit IRC21:32
*** yoeljacobsen has joined #ingres22:30
yoeljacobsenHello22:30
yoeljacobsenI'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 Outline22:31
yoeljacobsen* (section_nbr VARCHAR(15) NOT NULL PRIMARY KEY,22:31
yoeljacobsen* CHECK (section_nbr SIMILAR TO '([:digit:][:digit:]\.)+'));22:31
yoeljacobsen* \g22:31
yoeljacobsenExecuting . . .22:31
yoeljacobsencontinue22:31
yoeljacobsen* insert into outline values ('11.');\g22:31
yoeljacobsenExecuting . . .22:31
yoeljacobsenE_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
yoeljacobsenWhy is the constraint valioted?22:31
yoeljacobsenviolated..22:31

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!