Re: Bug #660: View name not stored in lowercase

Jacob (jacobpage(at)hotmail(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
View name not stored in lowercase

Long Description
Somehow, the PGAccess client created a view in my database with the name "AlbumList". This view cannot be dropped or queried because view names are folded to lowercase when executing SQL statements, so it just sits as an unreferenceable object in the catalog.

Unfortunately, I don't know the commands PGAccess executes to generate this problem, but obviously PostgreSQL lets capital letters escape its attention when adding to the catalog.

P.S. I am new to Postgres but am very impressed with the product. Great job!

Additional Details
------------------
Vacuuming doesn't remove the offending view.

The version of PostgreSQL I'm using is 7.2.1 compiled with GCC 3.1. The server is started with the option -i. My host is an AMD Duron 750 running RedHat Linux 7.1 (kernel version 2.4.18-0).

The error generated when refering to the offending view is "ERROR: Relation "albumlist" does not exist." The commands tried to refer to the view were "DROP VIEW AlbumList;" and "SELECT * FROM AlbumList;"

Sample Code

No file was uploaded with this report

> Unfortunately, I don't know the commands PGAccess executes to generate this problem, but obviously PostgreSQL lets capital letters escape its attention when adding to the catalog.

This doesn't help you much, but fwiw it is likely that pgAccess used
double-quotes when creating the view, but is not double-quoting the name
of the view when issuing the subsequent query.

- Thomas