Hi, The exact error I got when I executed -
"create table public.Data (iden text *not null*, value text, primary key)" was ok that's great thanks - much appreciated! Cheers (iden)); On Saturday, April 21, 2012 8:37:03 PM UTC+10, Steve McLeod wrote: > > I tried create table public.Data (iden text, value text, primary key > (iden)); > and it didn't work. I got an error, which I expected. Since an update a > while back, you can no longer create an index on a TEXT field. > > From the changelog for Version 1.3.158 (2011-07-17): > *It is now longer allowed to create an index on a CLOB or BLOB column > (except for in-memory databases or indexes), because recovery doesn't work > on such columns. Fulltext indexes on such column are still supported of > course.* > > On Friday, 20 April 2012 07:30:32 UTC+2, user wrote: >> >> Hi, >> >> FYI The following create table statement does not work - >> >> create table public.Data (iden text not null, value text, primary key >> (iden)); >> >> It seems as though h2 doesn't like the "not null" part of the create >> table statement. Note that this works on an older version (1.0.72) >> >> If I execute - >> >> create table public.Data (iden text, value text, primary key (iden)); >> >> on 1.3.165 it works fine. >> >> Cheers >> >> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/PEq-fpxN4eUJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
