Re: [gnome-db] Changing a field definition

[Murray Cumming <murrayc murrayc com>]

On Sat, 2004-05-01 at 20:48, Rodrigo Moya wrote:
> On Tue, 2004-04-27 at 09:27 +0200, Vivien wrote:
> > > On Sun, 2004-04-25 at 17:55, Rodrigo Moya wrote:
> > > Actually, I didn't think that the get_schema() was even an option for me
> > > when I want to change the field type. Or is the data_model returned by
> > > get_schema() writeable?
> > >
> > >> A better solution for this would be, I guess, to have create_table,
> > >> modify_table, etc methods on the provider.
> > 
> > I also believe that having in the providers at least:
> > create_table()
> > drop_table()
> >
> both of these are now added to CVS HEAD,

great.

>  only missing the implementation
> on each provider.

And gda_connection_create_table() and gda_connection_drop_table()
methods, I guess.

I'll try to add the implementations for postgres.
 
> > add_field_to_table()
> > delete_field_from_table()
> > modify_field()
> >
> hmm, I'd like to have a more 'elegant' way of doing it, like doing it
> via the data model (both the one returned by get_schema like any
> others). This involves more work on the providers, but I think it makes
> more sense, given we already have the update_column API in the data
> model.

Note that we already have vfuncs for update_column(), append_column(),
and remove_column() on the DataModel, but there are no implementations.