Hi, Could you use varchar instead of text?
create table public.Data (iden varchar not null, value text, primary key (iden)); Regards, Thomas On Monday, April 23, 2012, user wrote: > 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]<javascript:_e({}, 'cvml', > '[email protected]');> > . > To unsubscribe from this group, send email to > [email protected] <javascript:_e({}, 'cvml', > 'h2-database%[email protected]');>. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
