Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7. - Mailing list pgsql-general

From Emmanuel Charpentier
Subject Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7.
Date
Msg-id 3A8121DE.6A535C99@bacbuc.dyndns.org
Whole thread Raw
Responses Re: Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7.  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
I installed (with some minor worries) 7.1beta4 Debian packages (a thousand
thanks, Oliver !). On the whole, it looks *very* good.

I have some problems with the ODBC interface, that seems partially broken (see
the ODBC list).

My present problem is with views : There seems no way to retrieve a view
definition apart from the psql \dv {viewname} command or select definition
from pg_views where viewname={viewname}, which I found by trial and error.

- PgAccess 0.98.7 as packaged by Oliver Elphick allows the *creation* of a
view (which is then readable through psql's \dv), but does not display any
view. In other words, PgAccess "view" screen seems to be write-only. Ouch !

Hence a question : shouldn't the system (pg_* and pga_*) tables be somewhat
documented at least in the reference manual (and maybe cross-referenced in the
programmer's manual) ? They seem not to be at the time ...

--
Emmanuel Charpentier

pgsql-general by date:

Previous
From: "Mark Alliban"
Date:
Subject: Re: Number of open files
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?