>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
>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 simply qMembers) where you cannot access the object. And this can happen with any object -- usernames, tables.
This is also documented -- see User's Guide / SQL Syntax / Identifiers and Key Words.
The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp
Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
pgsql-cygwin by date
|Next:||From: Colin Mangiagalli||Date: 2003-02-19 09:41:01|
|Subject: Where does PostgreSQL get the date/time from?|
|Previous:||From: Yann.G||Date: 2003-02-19 01:32:16|
|Subject: Re: What could be the cause?|
pgsql-interfaces by date
|Next:||From: Gerhard Häring||Date: 2003-02-19 08:54:13|
|Subject: Re: Help with Win32 MingW build|
|Previous:||From: Michael Uman||Date: 2003-02-19 02:37:13|
|Subject: Help with Win32 MingW build|