Re: [gnome-db] Patch Postgres provider.



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
-- 
Rodrigo Moya <rodrigo gnome-db org>



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]