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. 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
testcase.tbz
Description: application/bzip-compressed-tar
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
