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

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

Responses

Browse pgsql-general by date

  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