Re: [gnome-db] Patch Postgres provider.
- From: Rodrigo Moya <rodrigo gnome-db org>
- To: Bas Driessen <bas driessen xobas com>
- Cc: GDA <gnome-db-list gnome org>
- Subject: Re: [gnome-db] Patch Postgres provider.
- Date: Thu, 28 Oct 2004 17:50:41 +0200
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]