--
Shachar Shemesh
Open Source integration consultant
Home page & resume - http://www.shemesh.biz/
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Shachar Shemesh
Your email address : psql@shemesh.biz
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : Windows XP Pro
PostgreSQL version (example: PostgreSQL-7.3.3): PostgreSQL-7.3.1wina1
Compiler used (example: gcc 2.95.2) : Binary package from the site
Please enter a FULL description of your problem:
------------------------------------------------
When sending SQL queries that are not double quoted, the documentation states
that postgresql should treat it as case independant. This is also the SQL standard.
Postgresql, instead, makes the identifiers in the query lowercase. While this is
equivalent if ALL queries are not double quoted, this is a major problem when
migrating data from other databases.
Also, the MFC rowset class opens the data using a query that does have double quotes,
which means that applications that are meant to work with more than one backend,
and which use the MFC class, do not work (and have no way of being made to work without
rewriting the entire application).
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
create table "Table" ( id int );
select * from Table;
You get "relation table not found".
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
When matching against unquoted IDs, simply ignore the case.