Re: [gnome-db] Per-table meta-data with capital letters in the table name?

[Vivien Malerba <vmalerba gmail com>]

2009/7/13 Murray Cumming <murrayc murrayc com>

> On Sun, 2009-07-05 at 19:20 +0200, Murray Cumming wrote:
> > On Sun, 2009-07-05 at 17:55 +0200, Vivien Malerba wrote:
> > > You won't be able to have at the same time a database abstraction
> > > layer and use user input without any validation. For example if you
> > > the user has a MyTable table name, then to use this table you _will_
> > > at some point have to check if you need quotes or not yourself.
> >
> > I always use quotes. I don't need to check.
>
> Vivien wrote:
> > Anyway, I've committed to git master and LIBGDA_4.0 branches >
> > corrections with documentation which explain the design choices that
> > were made.
>
> Thanks for the recent fixes. Things seem to work now in Glom but I
> wanted to check that we are really doing the right thing. I have some
> questions.
>
> 1.
> You added a section about SQL Identifiers that mentions quotes:
>
> But I find this surprising, and I doubt that it's true:
> http://git.gnome.org/cgit/libgda/tree/doc/C/libgda-4.0-docs.sgml#n465
> "
> Many people consider that using the quoted syntax should be avoided if
> possible because:
> - once an SQL identifier has been defined using the quoted syntax, it
> must always be used quoted, which is error prone especially if external
> tools are used on the database.
> "