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: | Raw Message | Whole Thread | 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 |