Hi, Yup that's what I've done now - works fine.
Thanks again! On Tuesday, April 24, 2012, Thomas Mueller wrote: > 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]. >> 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. >> > -- > 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]<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.
