Thanks Pat. On Mon, Aug 31, 2009 at 12:05 PM, Pat Allan <[email protected]>wrote:
> > Yes, you can (at this point in time) only have one define_index per > model. > > Also, make sure you stop Sphinx, reindex, and then restart Sphinx > whenever you change your index structure. > > -- > Pat > > On 31/08/2009, at 7:03 PM, sumeet panchal wrote: > > > include AssetCommons // this one don't have define_index > > include ManagedContent // this do have a define_index > > define_index do > > indexes :name > > indexes :location_geom, :type=>:string > > set_property :delta => true > > end > > > > I think this error is due to the fact I was having two define_index > > by mistake. And If I fix it this should work. > > Your comment will be valuable for me. > > > > Thanks > > > > On Mon, Aug 31, 2009 at 11:52 AM, Pat Allan <p...@freelancing- > > gods.com> wrote: > > > > What's the full contents of your define_index block in WorkingAsset? > > > > -- > > Pat > > > > On 31/08/2009, at 6:49 PM, sumeet panchal wrote: > > > > > Hi Pat, > > > > > > But Can you please tell me why I get that error for incompatible > > > schema. > > > > > > Thanks > > > > > > On Sun, Aug 30, 2009 at 3:37 PM, Pat Allan <p...@freelancing- > > > gods.com> wrote: > > > > > > Hi Sumeet > > > > > > It looks like you're using a custom library for PostgreSQL, and I'm > > > not even that experienced with that database system, so this is all > > > guesswork, but we need to return each point. > > > > > > Would something like the following work? > > > > > > has 'RADIANS(st_x(st_astest(location_geom)))', :as > > > => :latitude, :type => :float > > > has 'RADIANS(st_y(st_astest(location_geom)))', :as > > > => :longitude, :type => :float > > > > > > I'm not sure if I'm using the right methods, but you'll need to do > > > something like that to get it working with Sphinx. > > > > > > -- > > > Pat > > > > > > On 29/08/2009, at 7:43 PM, sumeet panchal wrote: > > > > > > > > > > > Hi, > > > > > > > > This is data normally in my column > > > > (0101000020AD1000000000000000C041406666666666D65CC0) its a > > geometry > > > > point. > > > > and when I did this : > > > > select st_astext(location_geom) from <table> where id=1; > > > > It gives: POINT(35.5 -115.35). > > > > this is type for column: location_geom :geometry point, 4269 > > > > biggest problem I am facing the error: > > > > ERROR: index 'working_asset_core': incompatible schemas: attribute > > > > count mismatch: 4 in schema 'working_asset_core_1', 5 in schema > > > > 'working_asset_core_0'. Whenever I try to add the attribute to > > > > define_index it gives me this error. > > > > > > > > thanks > > > > > > > > On Aug 29, 3:32 am, Pat Allan <[email protected]> wrote: > > > >> Hi Sumeet > > > >> > > > >> Can you give us an example of the data inside that column? Then I > > > >> might be able to suggest a SQL snippet to extract latitude and > > > >> longitude out for attributes. > > > >> > > > >> -- > > > >> Pat > > > >> > > > >> On 29/08/2009, at 12:54 AM, sumeet panchal wrote: > > > >> > > > >> > > > >> > > > >>> hi I am struggling with this for so long. > > > >> > > > >>> I have a field named location_geom : (geometry point). It have > > > >>> latitude and longitude. It stores value using georuby. > > > >>> So we can have methods like lat lon x y on it. > > > >>> Problem is that I want an attribute from it > > > >> > > > >>> What I did is > > > >> > > > >>> define_index > > > >>> indexes :name > > > >>> has "location_geom.lat" , :as => :latitude, :type => :float > > > >>> end > > > >> > > > >>> I need to index this field, if possible separately in latitude > > and > > > >>> longitude. > > > >>> please help. > > > >> > > > >>> And I also get an error again and again in indexing it is: > > > >>> when i do rake ts:in > > > >> > > > >>> ERROR: index 'working_asset_core': incompatible schemas: > > attribute > > > >>> count mismatch: 4 in schema 'working_asset_core_1', 5 in schema > > > >>> 'working_asset_core_0'. > > > >> > > > >>> what is cause and solution for this. > > > >>> Please Help. > > > >> > > > >>> Thanks > > > >>> Sumeet > > > >> > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" 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/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
