Re: [gnome-db] Auto-updated GdaMetaStore?

[Armin Burgmeier <armin arbur net>]

On Mon, 2009-01-12 at 15:56 +0100, Vivien Malerba wrote:
> 
> 
> 2009/1/12 Vivien Malerba <vmalerba gmail com>
>         
>         
>         2009/1/12 Armin Burgmeier <armin arbur net>
>         
>         
>                 On Fri, 2009-01-09 at 16:02 +0100, Vivien Malerba
>                 wrote:
>                 >
>                 >
>                 > 2009/1/9 Johannes Schmid <jhs jsschmid de>
>                 >         Hi!
>                 >
>                 >         OK, I think I got kind of a clue now. Seems
>                 I had some
>                 >         postgres
>                 >         permission problems but I fixed them now.
>                 >
>                 >         Anyway, it seems that update_meta_store()
>                 with no further
>                 >         arguments is
>                 >         working fine after an ALTER TABLE statement.
>                 But what would
>                 >         actually be
>                 >         much more useful, would be to update the
>                 meta store for a
>                 >         single table
>                 >         like you can specify with
>                 get_meta_store_data():
>                 >
>                 >         g_value_init (&value, G_TYPE_STRING);
>                 >                g_value_set_static_string (&value,
>                 "customer");
>                 >                model =
>                 gda_connection_get_meta_store_data (cnc,
>                 >         GDA_CONNECTION_META_FIELDS, &error, 1,
>                 "name", &value);
>                 >
>                 >         I would just like to update the meta_store
>                 for the table
>                 >         "customer". I
>                 >         am kind of lost in the database schema the
>                 documentation
>                 >         provides for
>                 >         GdaMetaStore.
>                 >
>                 > I know the doc is not up to the expectations...
>                 anyway, you can use a
>                 > specific GdaMetaContext for this purpose. See the
>                 attached test case.
>                 
>                 
>                 When doing such a partial metastore update for a
>                 specific table, then
>                 the types (GTypes) of all fields collapse to
>                 gchararray (at least for
>                 postgresql). Do I maybe need to update something else
>                 than "_tables" to
>                 get the column types correctly?
>                 
>                 Here is a testcase. After doing a complete metastore
>                 update, the types
>                 are correct, but when doing a partial update after
>                 that (without
>                 changing anything else in the database), all types
>                 become gchararray:
>                 
>                 http://arbur.net/stuff/partial-metastore-update-types.c
>                 
>                 Thanks,
>                 Armin
> 
> Here is a correcting patch (I'll commit it ASAP).

Great, thanks. I can confirm that this patch fixes the problem.

Armin