| From: | Emmanuel Charpentier <charpent(at)bacbuc(dot)dyndns(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Trouble with views (7.1beta4 Debian) and PgAccess 0.98.7. |
| Date: | 2001-02-07 10:22:22 |
| Message-ID: | 3A8121DE.6A535C99@bacbuc.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martin A. Marques | 2001-02-07 11:08:44 | Re: Re: new type proposal |
| Previous Message | Alexey Borzov | 2001-02-07 10:15:47 | Re[2]: Re: new type proposal |