Re: [gnome-db] gda_column_get_primary_key()

[Murray Cumming <murrayc murrayc com>]

On Thu, 2008-11-20 at 20:30 +0100, Vivien Malerba wrote:

>         I still don't understand. Is the "this field is a primary key"
>         information something that is stored in the server (PostgreSQL
>         in this
>         case) or not?
> 
> The default is, as for V3, that Libgda creates its own dictionary file
> (in V3 it was an XML file, and in V4 it's an SQLite DB file). This can
> be changed and it's possible to store the meta data in the database
> being accessed. See
> http://library.gnome.org/devel/libgda/unstable/gda-dict.html#GdaMetaStoreSetup for some example.

Is it normally in the database server, other than in this extra libgda
meta data that you store in the database?

I guess you use a special table to store that metadata. Is that table
name and data format documented somewhere? 

> Compared to the V3, using a database to store the meta data has the
> following benefits:
> * the data does need to be in memory at all times => more meta data
> types can be handled (indexes, triggers,...) at almost no cost
> * the Libgda's user can more easilly store his own data within in that
> database (it's like a normal GdaConnection with a small helper API).
> For example the gda-sql-4.0 console tool stores some user-defined SQL
> statements

> 
-- 
Murray Cumming
murrayc murrayc com
www.murrayc.com
www.openismus.com