Skip site navigation (1) Skip section navigation (2)

Re: PgAdmin problem

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: (view raw or whole thread)
Lists: pgsql-cygwinpgsql-interfaces

>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! 

Get your own FREE, personal Netscape Mail account today at

pgsql-cygwin by date

Next:From: Colin MangiagalliDate: 2003-02-19 09:41:01
Subject: Where does PostgreSQL get the date/time from?
Previous:From: Yann.GDate: 2003-02-19 01:32:16
Subject: Re: What could be the cause?

pgsql-interfaces by date

Next:From: Gerhard HäringDate: 2003-02-19 08:54:13
Subject: Re: Help with Win32 MingW build
Previous:From: Michael UmanDate: 2003-02-19 02:37:13
Subject: Help with Win32 MingW build

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group