| From: | s0lao(at)netscape(dot)net (S(dot) L(dot)) |
|---|---|
| To: | MAgrawal(at)coba(dot)usf(dot)edu ("Agrawal, Manish"), pgsql-interfaces(at)postgresql(dot)org ("'pgsql-interfaces(at)postgresql(dot)org'" ) |
| Cc: | pgsql-cygwin(at)postgresql(dot)org ("'pgsql-cygwin(at)postgresql(dot)org'") |
| Subject: | Re: PgAdmin problem |
| Date: | 2003-02-19 06:33:41 |
| Message-ID: | 4D1D1F9E.06B44767.00013D13@netscape.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-cygwin pgsql-interfaces |
Agrawal,
[...]
>
>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 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.
SLao
__________________________________________________________________
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Colin Mangiagalli | 2003-02-19 09:41:01 | Where does PostgreSQL get the date/time from? |
| Previous Message | Yann.G | 2003-02-19 01:32:16 | Re: What could be the cause? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerhard Häring | 2003-02-19 08:54:13 | Re: Help with Win32 MingW build |
| Previous Message | Michael Uman | 2003-02-19 02:37:13 | Help with Win32 MingW build |