Thread: Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7.

Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7.

From
Emmanuel Charpentier
Date:
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

Re: Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7.

From
"Richard Huxton"
Date:
From: "Emmanuel Charpentier" <charpent@bacbuc.dyndns.org>


> 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 ...

try "psql -E" - this will show the queries that \dv uses.

- Richard Huxton


Re: Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7.

From
Peter Eisentraut
Date:
Emmanuel Charpentier writes:

> 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 ...

http://www.postgresql.org/devel-corner/docs/postgres/catalogs.htm

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/