Re: [gnome-db] Questions regarding gda_connection_create_table

[Rodrigo Moya <rodrigo gnome-db org>]

On Tue, 2004-10-05 at 12:40 +1000, Bas Driessen wrote:
> Hello,
> 
> I would like to use the (relatively) new functions
> gda_connection_create_table  and gda_connection_drop_table. Couple of
> questions:
> 
> -1 Is this working technology and has this been ported to the
> providers? I am using PostgreSQL at the moment as database.
> 
it is not really implemented yet for any provider :( Maybe you could
provide a patch for the PostgreSQL provider implementation? It just
means implementing the create_table/drop_table virtual methods in gda-
postgres-provider.c

> -2 Are there any examples on the exact use? There is nothing in the
> testing directory, mailing lists or documentations. During the
> development of this function, there must have been some examples/test
> code to test it. Would appreciate if someone can share anything  about
> this (even a one-liner)
> 
> -3 I see in the GdaFieldAttributes struct that values can be set for
> primary key/unique key. How about compound keys/indexes? Is that
> possible or should there be a gda_connection_create_index to do this?
> 
you can set more than one field to be the primary key, so the provider
should deal with that and create the correct PK for the table.
-- 
Rodrigo Moya <rodrigo gnome-db org>