Date: Wed, 19 Feb 2003 01:33:41 -0500
From: s0lao@netscape.net (S. L.)
To: MAgrawal@coba.usf.edu ("Agrawal, Manish"),
	pgsql-interfaces@postgresql.org ("'pgsql-interfaces@postgresql.org'" )
Cc: pgsql-cygwin@postgresql.org ("'pgsql-cygwin@postgresql.org'")
Subject: Re: PgAdmin problem
MIME-Version: 1.0
Message-ID: <4D1D1F9E.06B44767.00013D13@netscape.net>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Agrawal,=20

[...]
>
>But though this view is available as an object in the pgsql database, I am
>unable to use it in an application. It also appears to be unavailable from
>psql.
>
>I have a link to a screenshot that shows what is happening. qMembers is the
>view, I can see it by using \d in psql but I cannot drop the view.
>
[...]

This problem should be solved by qoutting (e.g. use "qMembers" instead simp=
ly qMembers) where you cannot access the object. And this can happen with a=
ny object -- usernames, tables.
This is also documented -- see User's Guide / SQL Syntax / Identifiers and =
Key Words.

SLao

__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels=
.netscape.com/ns/browsers/download.jsp=20

Get your own FREE, personal Netscape Mail account today at http://webmail.n=
etscape.com/