Re: [gnome-db] Constraints support?

[Rodrigo Moya <rodrigo gnome-db org>]

On Sat, 2003-08-02 at 03:27, Mårten Svantesson wrote:
> Rodrigo Moya <rodrigo gnome-db org> writes:
> 
> > On Fri, 2003-08-01 at 20:22, Mårten Svantesson wrote:
> >> Hi!
> >> 
> >> I was looking around in the gda documentation for any descriptions of
> >> support for foreign key column constraints. I couldn't say for sure if
> >> I found it... Is gda_field_attributes_get_references supposed to
> >> return such constraints for a field?
> >
> > yes
> 
> OK. Looking through the code for the database providers it seems like
> none of them have support for delivering that information.
>
hmm, IIRC the MySQL provider implements it.

>  When is the
> support for this planned to be added?
>
This should be fixed before 1.0, at least for the most used providers
(postgres, mysql). So please, could you file new bugs at
bugzilla.gnome.org for all the missing providers?

>  And how exactly will the
> information be stored? The data type (gchar *) could hold the
> information in various ways.
>
I think we decided to use table.field_name as the format for that field.

cheers