============================================================================
                        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.