Re: [gnome-db] Patch Postgres provider.

[Alan Knowles <alan akbkhome com>]

All databases quote identifiers like this, some databases use ", mysql 
uses ` (backquote)... cant remember what the databases use. - is it 
possible to add a method to query the driver for this quote character?

Regards
Alan




Rodrigo Moya wrote:

> On Wed, 2004-10-27 at 16:52 +1000, Bas Driessen wrote:
>  
>
> > Anyway, when using gda_data_model_append_row and a column name is a
> > reserved name like "desc" or "typeid", the INSERT query is
> > unsuccessful and returns an error. What this patch does is place "
> > arround the column names. So:
> >
> > INSERT INTO parts(part_id, desc, price) VALUES (123, 'Test', 12.34)
> >
> > becomes
> >
> > INSERT INTO parts("part_id", "desc", "price") VALUES (123, 'Test',
> > 12.34)
> >
> > and all works fine. 
> >
> > Sure, it is probably not a good idea to use reserved names for column
> > names, but people will be using them not knowing that some names are
> > special.
> >
> >    
> patch applied, thanks
>