Обсуждение: PgAdmin problem

Поиск
Список
Период
Сортировка

PgAdmin problem

От
"Agrawal, Manish"
Дата:

I have a peculiar problem with PgAdmin. I converted an Access database using pgMigration in pgadmin. I then created a view from within pgadmin.

 

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.

 

http://faculty94100.coba.usf.edu:8081/view_problem.bmp

 

Can anyone help me with this issue. This problem is preventing me from being able to use pgadmin to create views.

 

Thanks

Manish

_________________________________

Manish Agrawal

Asstt. Prof., Dept. of ISDS, Univ. of South Florida

4202 E. Fowler Ave., CIS 1040, Tampa, Fl 33620 - 7800

(813)-974-6716 (W) 974-6749 (FAX)

magrawal@coba.usf.edu

______________________________________

My default office suite is Openoffice, the simple-to-use, opensource Office Suite for Windows, Linux and Macs. http://www.openoffice.org

 

 

Re: PgAdmin problem

От
s0lao@netscape.net (S. L.)
Дата:
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/

Re: PgAdmin problem

От
"Agrawal, Manish"
Дата:

You have to sign up for the mailing lists at www.postgreswl.org. Depending upon your use, the relevant lists are:

 

pgsql-cygwin@postgresql.org   : for general pgsql questions

pgsql-interfaces@postgresql.org : for pgadmin questions

pgsql-jdbc@postgresql.org       : for jdbc issues

 

Since you apparently got my email, I would think that you are already subscribed

 

Manish

 

_________________________________

Manish Agrawal

Asstt. Prof., Dept. of ISDS, Univ. of South Florida

4202 E. Fowler Ave., CIS 1040, Tampa, Fl 33620 - 7800

(813)-974-6716 (W) 974-6749 (FAX)

magrawal@coba.usf.edu

______________________________________

I use Openoffice, the simple, free Office Suite for Windows/Linux/Macs that works with existing documents. http://www.openoffice.org

 

-----Original Message-----
From: Pablo Pérez [mailto:pabloperez@virzone.com]
Sent: Sunday, February 16, 2003 7:46 PM
To: MAgrawal@coba.usf.edu
Subject: Re: [CYGWIN] PgAdmin problem

 

Hi I would like to know how can I post a message or where can I do it.

 

 

 

_________________________________________________________________
  IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí

Вложения