Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7.
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
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
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/