Re: Bug #661: Update to previous bug report

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
Update to previous bug report

Long Description
I discovered that PGAccess created the view by directly manipulating the pg_class system table. I was able to remove the view with "DELETE FROM pg_class WHERE relname = 'AlbumList';." Perhaps constraints should be placed on the system tables to disallow invalid data. (Or perhaps I can stop using beta tools :)

Sample Code

No file was uploaded with this report

You can use case-sensitive identifiers (like your "AlbumList" by putting
double quotes around them.

CREATE VIEW "Foo" ...

will create a view called Foo, whereas

CREATE VIEW Foo or CREATE VIEW foo

both create a view called foo

So, to access your AlbumList, just do SELECT FROM "AlbumList" ...

To delete it, DROP VIEW "AlbumList".

Doesn't seem to be a bug at all, just a misudnerstanding of the role of
quoted system identifiers in SQL.

HTH.

Joel BURTON | joel(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant

> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org]On Behalf Of
> pgsql-bugs(at)postgresql(dot)org
> Sent: Tuesday, May 07, 2002 11:52 PM
> To: pgsql-bugs(at)postgresql(dot)org
> Subject: [BUGS] Bug #661: Update to previous bug report
>
>
> 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
> Update to previous bug report
>
> Long Description
> I discovered that PGAccess created the view by directly
> manipulating the pg_class system table. I was able to remove the
> view with "DELETE FROM pg_class WHERE relname = 'AlbumList';."
> Perhaps constraints should be placed on the system tables to
> disallow invalid data. (Or perhaps I can stop using beta tools :)
>
> Sample Code
>
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>