2009/1/12 Vivien Malerba <[email protected]>

>
>
> 2009/1/12 Armin Burgmeier <[email protected]>
>
> On Fri, 2009-01-09 at 16:02 +0100, Vivien Malerba wrote:
>> >
>> >
>> > 2009/1/9 Johannes Schmid <[email protected]>
>> >         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).

Vivien

Attachment: PATCH
Description: Binary data

_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list

Reply via email to