Обсуждение: PgAdmin problem
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
_________________________________
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)
______________________________________
My default office suite is Openoffice, the simple-to-use, opensource Office Suite for Windows, Linux and Macs. http://www.openoffice.org
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/
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
_________________________________
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)
______________________________________
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í