PgAdmin problem

From: "Agrawal, Manish" <MAgrawal(at)coba(dot)usf(dot)edu>
To: "'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: PgAdmin problem
Date: 2003-02-18 23:25:12
Message-ID: 00A42578900AD411BCFD00A0C978DC9304DC020B@mail.coba.usf.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-interfaces

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
<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 <http://coba.usf.edu/departments/isds/faculty/agrawal/index.html>
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(at)coba(dot)usf(dot)edu <mailto:magrawal(at)coba(dot)usf(dot)edu>

______________________________________

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

Browse pgsql-cygwin by date

  From Date Subject
Next Message Yann.G 2003-02-19 01:32:16 Re: What could be the cause?
Previous Message Jason Tishler 2003-02-18 19:55:47 Updated Cygwin Package: postgresql-7.3.2-1

Browse pgsql-interfaces by date

  From Date Subject
Next Message ljb 2003-02-19 01:05:19 Re: Announce: A pure-Tcl interface ... PgAccess, Protocol Version
Previous Message C. Maj 2003-02-18 18:02:46 Re: Bit maps & GIF