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

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 (view raw or flat)
Thread:
Lists: pgsql-cygwinpgsql-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> 

 

 

pgsql-cygwin by date

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

pgsql-interfaces by date

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

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