Re: Custom field _post_create_sql()

2007-05-30 Thread theju
Though I am not conversant with the details of the GIS fundas, here is my observationtheir application gave a very good pointer to people who always wanted to do custom field development. I wouldn't be happy to see SQL statements be used in the class (even though it gets the work because I

Re: Custom field _post_create_sql()

2007-05-29 Thread Justin Bronn
> In PostGIS, the AddGeometryColumn() function needs to be run separately > after the create table. It adds the geometry field to the table, adds > its definition (projection, geometry type, dimensions) to the > 'geometry_columns' table, creates a number of constraints, etc. Thanks, Rob, for the

Re: Custom field _post_create_sql()

2007-05-29 Thread Malcolm Tredinnick
On Tue, 2007-05-29 at 11:47 -0500, Joseph Kocherhans wrote: > On 5/29/07, Adrian Holovaty <[EMAIL PROTECTED]> wrote: > > > > Malcolm's _get_field_sql() question is a good one -- I'm +1 on adding > > that method to the fields. Only thing is, does _get_field_sql() get > > passed the database

Re: Custom field _post_create_sql()

2007-05-29 Thread Robert Coup
Malcolm Tredinnick wrote: > GIS guys, any particular reasons for the approach you took? -- laziness? > economy? "it works, dammit!"? technical reason against the above? > In PostGIS, the AddGeometryColumn() function needs to be run separately after the create table. It adds the geometry field

Re: Custom field _post_create_sql()

2007-05-29 Thread Joseph Kocherhans
On 5/29/07, Adrian Holovaty <[EMAIL PROTECTED]> wrote: > > Malcolm's _get_field_sql() question is a good one -- I'm +1 on adding > that method to the fields. Only thing is, does _get_field_sql() get > passed the database backend? If the method is going in, I think passing in the db backend would

Re: Custom field _post_create_sql()

2007-05-29 Thread Adrian Holovaty
On 5/29/07, Jacob Kaplan-Moss <[EMAIL PROTECTED]> wrote: > I hadn't heard back from Adrian yet; I want to make sure to have his OK. > > I'll let the GIS folks answer your question about _get_field_sql(); my > impression is that PostGIS at least makes you declare GIS fields > *after* you declare

Custom field _post_create_sql()

2007-05-29 Thread Malcolm Tredinnick
On Sat, 2007-05-26 at 01:53 -0500, Jacob Kaplan-Moss wrote: > On 5/26/07, Justin Bronn <[EMAIL PROTECTED]> wrote: > > We encountered a similar problem on the GIS branch. Specifically, the > > OpenGIS specification requires that compliant spatial databases add > > geometry columns by calling the