Hi! Thanks a lot, I think that is what I needed. Regards, Johannes Am Freitag, den 09.01.2009, 16:02 +0100 schrieb Vivien Malerba: > > > 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. > > Here is a sample output from my test DB: > > ./upd_single_table customers > Updating the meta store for the 'customers' table > Number of tables: 1 > Columns: 5 > table_catalog | table_schema | table_name | column_name > --------------+--------------+------------+------------------ > sales | public | customers | id > sales | public | customers | name > sales | public | customers | default_served_by > sales | public | customers | country > sales | public | customers | city > (5 rows) > > > ./upd_single_table pg_database > Updating the meta store for the 'pg_database' table > Number of tables: 1 > Columns: 11 > table_catalog | table_schema | table_name | column_name > --------------+--------------+-------------+-------------- > sales | pg_catalog | pg_database | datname > sales | pg_catalog | pg_database | datdba > sales | pg_catalog | pg_database | encoding > sales | pg_catalog | pg_database | datistemplate > sales | pg_catalog | pg_database | datallowconn > sales | pg_catalog | pg_database | datconnlimit > sales | pg_catalog | pg_database | datlastsysoid > sales | pg_catalog | pg_database | datfrozenxid > sales | pg_catalog | pg_database | dattablespace > sales | pg_catalog | pg_database | datconfig > sales | pg_catalog | pg_database | datacl > (11 rows) > > Regards, > > Vivien > > > >
Attachment:
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil