[gdal-dev] Call for discusson on RFC 52 Strict OGR SQL quoting

[Dmitriy Baryshnikov]

Hi,

I just check PostGIS. Create a table with name test.test in test schema. 
The result looks so:
CREATE TABLE test."test.test"
(
   id serial NOT NULL
);

Also, if schema name have spaces it'll be look like: "test 
test"."test.test".

And what about other DBs?

Best regards,
     Dmitry

26.01.2015 23:49, Jukka Rahkonen пишет:
> Even Rouault <even.rouault <at> spatialys.com> writes:
>
>> Hi,
>>
>> This is a call for discussion on the new "RFC 52 - Strict OGR SQL quoting",
>> based on an older ticket.
>>
>> http://trac.osgeo.org/gdal/wiki/rfc52_strict_sql_quoting
>>
>> Summary :
>>
>> This RFC proposes that OGR SQL enforces strict quoting rules for SQL literals
>> and identifiers.
> Hi,
>
> Could there be a need to think about the "schema"."table" structure? I have
> some memories about (silly) users having table names with dots like
> "MY.TABLE". If I remember right, with some database the SQL query
>
> SELECT "field" FROM "MY.TABLE"
>
> was being interpreted wrongly as "select field named 'field' from table
> named 'table' from schema named 'my'".
>
> I do not really know if this trouble belongs to GDAL at all but I share my
> weigh memories anyhow.
>
> -Jukka Rahkonen-
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>